Campo calculado

--===============5880337812430853819==
Content-Type: multipart/alternative; boundary="f4f5e80e906062e9f0056a1dc53b"

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

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


--=20
The Ubuntu Counter Project - user number # 33192
<http://ubuntucounter.geekosophical.net>

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

<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.campo_calculado_idade=
,</div><div>from tabela t</div><div><br></div><div>onde:</div><div><span st=
yle=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;fon=
t-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-=
weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-tran=
sform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255=
,255);text-decoration-style:initial;text-decoration-color:initial;float:non=
e;display:inline">t.campo_calculado_idade =3D date_part(&#39;year&#39;, age=
(<span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:=
small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:nor=
mal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;=
text-transform:none;white-space:normal;word-spacing:0px;background-color:rg=
b(255,255,255);text-decoration-style:initial;text-decoration-color:initial;=
float:none;display:inline">t.data_nascimento</span>) )</span><br></div><div=
><br></div><div>N=C3=A3o quero usar view,=C2=A0 preciso desse campo na tabe=
la.</div><div><br></div><div>Obrigado</div><div><br clear=3D"all"><div><br>=
</div>-- <br><div class=3D"gmail_signature"><div><font size=3D"3"><span sty=
le=3D"line-height:24px"><a href=3D"http://ubuntucounter.geekosophical.net" =
target=3D"_blank"><font face=3D"tahoma, sans-serif">The Ubuntu Counter Proj=
ect - user number # 33192</font></a><br></span></font></div></div>
</div></div>

--f4f5e80e906062e9f0056a1dc53b--

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

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KcGdici1nZXJh
bCBtYWlsaW5nIGxpc3QKcGdici1nZXJhbEBsaXN0YXMucG9zdGdyZXNxbC5vcmcuYnIKaHR0cHM6
Ly9saXN0YXMucG9zdGdyZXNxbC5vcmcuYnIvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3BnYnIt
Z2VyYWw=

--===============5880337812430853819==--