Re: Campo calculado

--===============0793068721455663598==
Content-Type: multipart/alternative; boundary="00000000000012825b056a1dff5e"

--00000000000012825b056a1dff5e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Basicamente voc=C3=AA dever=C3=A1 cria uma function e uma trigger e toda ve=
z que
houver o evento insert e ou update executar'aa fun=C3=A7=C3=A3o que calcula=
r=C3=A1 o
resultado no campo.

No exemplo abaixo a coluna3 =C3=A9 calculada a partir de uma somatoria dos
valores da coluna1 e coluna2, por=C3=A9m vc ajusta a realidade de seu caucu=
lo

func=C3=A3o:

CREATE OR REPLACE FUNCTION "public"."calcular" () RETURNS trigger AS'
begin
     if (new.coluna1 is null) or (new.coluna2 is null) then
         Raise notice ''Factores para o calculo nulos'';
         new.coluna3 :=3D 0;
     else
             new.coluna3 :=3D (new.coluna1 + new.coluna2);
     end if;
     return new;
end;
'LANGUAGE 'plpgsql' IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER;


trigger:

CREATE TRIGGER "fazcalculo" BEFORE INSERT OR UPDATE
ON "public"."nomeTabela" FOR EACH ROW
EXECUTE PROCEDURE "public"."calcular"();



Atenciosamente,

*M=C3=A1rio R. de Castro*




Em 18 de abril de 2018 08:29, Rog=C3=A9rio Martins <[email protected]>
escreveu:

> Bom dia pessoal !
>
> =C3=89 poss=C3=ADvel criar no PG 9.6 um campo calculado ?
> Exemplo:
>
> select
> t.data_nascimento,
> t.campo_calculado_idade,
> from tabela t
>
> onde:
> t.campo_calculado_idade =3D date_part('year', age(t.data_nascimento) )
>
> N=C3=A3o quero usar view,  preciso desse campo na tabela.
>
> Obrigado
>
>
> --
> The Ubuntu Counter Project - user number # 33192
> <http://ubuntucounter.geekosophical.net>
>
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral-b/[email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>

--00000000000012825b056a1dff5e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Basicamente voc=C3=AA dever=C3=A1 cria uma function e uma =
trigger e toda vez que houver o evento insert e ou update executar&#39;aa f=
un=C3=A7=C3=A3o que calcular=C3=A1 o resultado no campo.<div><br></div><div=
>No exemplo abaixo a coluna3 =C3=A9 calculada a partir de uma somatoria dos=
 valores da coluna1 e coluna2, por=C3=A9m vc ajusta a realidade de seu cauc=
ulo</div><div><br></div><div><span style=3D"color:rgb(0,0,0);font-family:Ve=
rdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal=
;font-variant-ligatures:normal;font-variant-caps:normal;letter-spacing:norm=
al;text-align:start;text-indent:0px;text-transform:none;white-space:normal;=
word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:in=
itial;text-decoration-color:initial;font-weight:bold">func=C3=A3o</span><sp=
an style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,san=
s-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:normal;f=
ont-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:st=
art;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px=
;background-color:rgb(255,255,255);text-decoration-style:initial;text-decor=
ation-color:initial;float:none;display:inline">:</span><br style=3D"color:r=
gb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:1=
3.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:no=
rmal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px=
;text-transform:none;white-space:normal;word-spacing:0px;background-color:r=
gb(255,255,255);text-decoration-style:initial;text-decoration-color:initial=
"><br style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,=
sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:norma=
l;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align=
:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:=
0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-de=
coration-color:initial"><span style=3D"color:rgb(0,0,0);font-family:Verdana=
,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font=
-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-s=
pacing:normal;text-align:start;text-indent:0px;text-transform:none;white-sp=
ace:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decorati=
on-style:initial;text-decoration-color:initial;float:none;display:inline">C=
REATE OR REPLACE FUNCTION &quot;public&quot;.&quot;calcular&quot; () RETURN=
S trigger AS&#39;</span><br style=3D"color:rgb(0,0,0);font-family:Verdana,G=
eneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font-v=
ariant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spa=
cing:normal;text-align:start;text-indent:0px;text-transform:none;white-spac=
e:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration=
-style:initial;text-decoration-color:initial"><span style=3D"color:rgb(0,0,=
0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;=
font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;fo=
nt-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-t=
ransform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,=
255,255);text-decoration-style:initial;text-decoration-color:initial;float:=
none;display:inline">begin</span><br style=3D"color:rgb(0,0,0);font-family:=
Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:norm=
al;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;l=
etter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;w=
hite-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-d=
ecoration-style:initial;text-decoration-color:initial"><span style=3D"color=
:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size=
:13.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:=
normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0=
px;text-transform:none;white-space:normal;word-spacing:0px;background-color=
:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initi=
al;float:none;display:inline">=C2=A0=C2=A0=C2=A0=C2=A0 if (new.coluna1 is n=
ull) or (new.coluna2 is null) then<span>=C2=A0</span></span><br style=3D"co=
lor:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-s=
ize:13.44px;font-style:normal;font-variant-ligatures:normal;font-variant-ca=
ps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-inden=
t:0px;text-transform:none;white-space:normal;word-spacing:0px;background-co=
lor:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:in=
itial"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica=
,Arial,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligature=
s:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;tex=
t-align:start;text-indent:0px;text-transform:none;white-space:normal;word-s=
pacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;=
text-decoration-color:initial;float:none;display:inline">=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Raise notice &#39;&#39;Factores para o calcu=
lo nulos&#39;&#39;;</span><br style=3D"color:rgb(0,0,0);font-family:Verdana=
,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font=
-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-s=
pacing:normal;text-align:start;text-indent:0px;text-transform:none;white-sp=
ace:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decorati=
on-style:initial;text-decoration-color:initial"><span style=3D"color:rgb(0,=
0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44p=
x;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;=
font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text=
-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(25=
5,255,255);text-decoration-style:initial;text-decoration-color:initial;floa=
t:none;display:inline">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 new=
.coluna3 :=3D 0;</span><br style=3D"color:rgb(0,0,0);font-family:Verdana,Ge=
neva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font-va=
riant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spac=
ing:normal;text-align:start;text-indent:0px;text-transform:none;white-space=
:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-=
style:initial;text-decoration-color:initial"><span style=3D"color:rgb(0,0,0=
);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;f=
ont-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;fon=
t-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-tr=
ansform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,2=
55,255);text-decoration-style:initial;text-decoration-color:initial;float:n=
one;display:inline">=C2=A0=C2=A0=C2=A0=C2=A0 else</span><br style=3D"color:=
rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:=
13.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:n=
ormal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0p=
x;text-transform:none;white-space:normal;word-spacing:0px;background-color:=
rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initia=
l"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Ari=
al,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:no=
rmal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-al=
ign:start;text-indent:0px;text-transform:none;white-space:normal;word-spaci=
ng:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text=
-decoration-color:initial;float:none;display:inline">=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 new.coluna3 :=3D (new.c=
oluna1 + new.coluna2);</span><br style=3D"color:rgb(0,0,0);font-family:Verd=
ana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;f=
ont-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;lette=
r-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white=
-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decor=
ation-style:initial;text-decoration-color:initial"><span style=3D"color:rgb=
(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.=
44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:norm=
al;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;t=
ext-transform:none;white-space:normal;word-spacing:0px;background-color:rgb=
(255,255,255);text-decoration-style:initial;text-decoration-color:initial;f=
loat:none;display:inline">=C2=A0=C2=A0=C2=A0=C2=A0 end if;</span><br style=
=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;=
font-size:13.44px;font-style:normal;font-variant-ligatures:normal;font-vari=
ant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text=
-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;backgro=
und-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-co=
lor:initial"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Hel=
vetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font-variant-li=
gatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:norm=
al;text-align:start;text-indent:0px;text-transform:none;white-space:normal;=
word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:in=
itial;text-decoration-color:initial;float:none;display:inline">=C2=A0=C2=A0=
=C2=A0=C2=A0 return new;</span><br style=3D"color:rgb(0,0,0);font-family:Ve=
rdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal=
;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;let=
ter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;whi=
te-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-dec=
oration-style:initial;text-decoration-color:initial"><span style=3D"color:r=
gb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:1=
3.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:no=
rmal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px=
;text-transform:none;white-space:normal;word-spacing:0px;background-color:r=
gb(255,255,255);text-decoration-style:initial;text-decoration-color:initial=
;float:none;display:inline">end;<span>=C2=A0</span></span><br style=3D"colo=
r:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-siz=
e:13.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps=
:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:=
0px;text-transform:none;white-space:normal;word-spacing:0px;background-colo=
r:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:init=
ial"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,A=
rial,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:=
normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-=
align:start;text-indent:0px;text-transform:none;white-space:normal;word-spa=
cing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;te=
xt-decoration-color:initial;float:none;display:inline">&#39;LANGUAGE &#39;p=
lpgsql&#39; IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER;<span>=C2=A0</s=
pan></span><br style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helveti=
ca,Arial,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatu=
res:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;t=
ext-align:start;text-indent:0px;text-transform:none;white-space:normal;word=
-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initia=
l;text-decoration-color:initial"><br style=3D"color:rgb(0,0,0);font-family:=
Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:norm=
al;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;l=
etter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;w=
hite-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-d=
ecoration-style:initial;text-decoration-color:initial"><br style=3D"color:r=
gb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:1=
3.44px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:no=
rmal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px=
;text-transform:none;white-space:normal;word-spacing:0px;background-color:r=
gb(255,255,255);text-decoration-style:initial;text-decoration-color:initial=
"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Aria=
l,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:nor=
mal;font-variant-caps:normal;letter-spacing:normal;text-align:start;text-in=
dent:0px;text-transform:none;white-space:normal;word-spacing:0px;background=
-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color=
:initial;font-weight:bold">trigger:</span><br style=3D"color:rgb(0,0,0);fon=
t-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-s=
tyle:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-wei=
ght:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transfo=
rm:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,25=
5);text-decoration-style:initial;text-decoration-color:initial"><br style=
=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;=
font-size:13.44px;font-style:normal;font-variant-ligatures:normal;font-vari=
ant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text=
-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;backgro=
und-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-co=
lor:initial"><span style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Hel=
vetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font-variant-li=
gatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:norm=
al;text-align:start;text-indent:0px;text-transform:none;white-space:normal;=
word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:in=
itial;text-decoration-color:initial;float:none;display:inline">CREATE TRIGG=
ER &quot;fazcalculo&quot; BEFORE INSERT OR UPDATE<span>=C2=A0</span></span>=
<br style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sa=
ns-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:normal;=
font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:s=
tart;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0p=
x;background-color:rgb(255,255,255);text-decoration-style:initial;text-deco=
ration-color:initial"><span style=3D"color:rgb(0,0,0);font-family:Verdana,G=
eneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;font-v=
ariant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spa=
cing:normal;text-align:start;text-indent:0px;text-transform:none;white-spac=
e:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration=
-style:initial;text-decoration-color:initial;float:none;display:inline">ON =
&quot;public&quot;.&quot;nomeTabela&quot; FOR EACH ROW<span>=C2=A0</span></=
span><br style=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Ari=
al,sans-serif;font-size:13.44px;font-style:normal;font-variant-ligatures:no=
rmal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-al=
ign:start;text-indent:0px;text-transform:none;white-space:normal;word-spaci=
ng:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text=
-decoration-color:initial"><span style=3D"color:rgb(0,0,0);font-family:Verd=
ana,Geneva,Helvetica,Arial,sans-serif;font-size:13.44px;font-style:normal;f=
ont-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;lette=
r-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white=
-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decor=
ation-style:initial;text-decoration-color:initial;float:none;display:inline=
">EXECUTE PROCEDURE &quot;public&quot;.&quot;calcular&quot;();</span><br st=
yle=3D"color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-ser=
if;font-size:13.44px;font-style:normal;font-variant-ligatures:normal;font-v=
ariant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;t=
ext-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;back=
ground-color:rgb(255,255,255);text-decoration-style:initial;text-decoration=
-color:initial"><br></div><div class=3D"gmail_extra"><br clear=3D"all"><div=
><div class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=
=3D"ltr"><p></p><p><br><font color=3D"#1f497d" face=3D"Calibri, sans-serif"=
><span style=3D"font-size:15px">Atenciosamente</span></font>,</p><p><b styl=
e=3D"color:rgb(255,102,0);font-family:Tahoma,sans-serif;font-size:large;lin=
e-height:13px">M=C3=A1rio R. de Castro</b></p><table border=3D"0" cellspaci=
ng=3D"0" cellpadding=3D"0" align=3D"left" width=3D"665" style=3D"font-size:=
12px;font-family:Arial;border:1px dotted rgb(127,124,117);width:500pt;borde=
r-collapse:collapse;height:0px;background-color:rgb(255,255,255)"><tbody><t=
r style=3D"min-height:10px"><td width=3D"230" style=3D"border:1px dotted rg=
b(127,124,117);width:200pt;padding:0cm"></td><td width=3D"433" style=3D"bor=
der:1px dotted rgb(127,124,117);width:324.55pt;padding:0cm"></td><td width=
=3D"2" style=3D"border:1px dotted rgb(127,124,117);width:1.45pt;padding:0cm=
"></td></tr></tbody></table><p></p><p style=3D"font-family:Arial;font-size:=
12px"><span lang=3D"EN-US">=C2=A0</span></p><p><span lang=3D"EN-US"></span>=
</p><p></p><p></p></div></div></div>
<br><div class=3D"gmail_quote">Em 18 de abril de 2018 08:29, Rog=C3=A9rio M=
artins <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt;</span> escreveu:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex"><div dir=3D"ltr">Bom dia pessoal !<div><br></div><div>=C3=
=89 poss=C3=ADvel criar no PG 9.6 um campo calculado ?</div><div>Exemplo:</=
div><div><br></div><div>select</div><div>t.data_nascimento,</div><div>t.cam=
po_calculado_idade,</div><div>from tabela t</div><div><br></div><div>onde:<=
/div><div><span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;f=
ont-size:small;font-style:normal;font-variant-ligatures:normal;font-variant=
-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-in=
dent:0px;text-transform:none;white-space:normal;word-spacing:0px;background=
-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color=
:initial;float:none;display:inline">t.campo_calculado_idade =3D date_part(&=
#39;year&#39;, age(<span style=3D"color:rgb(34,34,34);font-family:arial,san=
s-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;fon=
t-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:star=
t;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;b=
ackground-color:rgb(255,255,255);text-decoration-style:initial;text-decorat=
ion-color:initial;float:none;display:inline">t.data_nascimento</span>) )</s=
pan><br></div><div><br></div><div>N=C3=A3o quero usar view,=C2=A0 preciso d=
esse campo na tabela.</div><div><br></div><div>Obrigado</div><span class=3D=
"HOEnZb"><font color=3D"#888888"><div><br clear=3D"all"><div><br></div>-- <=
br><div class=3D"m_-3934836972201033966gmail_signature"><div><font size=3D"=
3"><span style=3D"line-height:24px"><a href=3D"http://ubuntucounter.geekoso=
phical.net" target=3D"_blank"><font face=3D"tahoma, sans-serif">The Ubuntu =
Counter Project - user number # 33192</font></a><br></span></font></div></d=
iv>
</div></font></span></div>
<br>______________________________<wbr>_________________<br>
pgbr-geral mailing list<br>
<a href=3D"mailto:pgbr-geral-b/[email protected]">pgbr-geral-b/[email protected]=
stgresql.<wbr>org.br</a><br>
<a href=3D"https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-g=
eral" rel=3D"noreferrer" target=3D"_blank">https://listas.postgresql.org.<w=
br>br/cgi-bin/mailman/listinfo/<wbr>pgbr-geral</a><br></blockquote></div><b=
r></div></div>

--00000000000012825b056a1dff5e--

--===============0793068721455663598==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KcGdici1nZXJh
bCBtYWlsaW5nIGxpc3QKcGdici1nZXJhbEBsaXN0YXMucG9zdGdyZXNxbC5vcmcuYnIKaHR0cHM6
Ly9saXN0YXMucG9zdGdyZXNxbC5vcmcuYnIvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3BnYnIt
Z2VyYWw=

--===============0793068721455663598==--