Re: Campo calculado

--===============2642189560603153003==
Content-Type: multipart/alternative; boundary="883d24f220a0b2c043056a1e0dd4"

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

Boam dia...  Rog=C3=A9rio Martins

Eu usaria isso... faz o mesmo resultado.... ou o campo tem que ser guardado
na tabela?

select
t.data_nascimento,
date_part('year', age(t.data_nascimento) ) as t.campo_calculado_idade
from tabela t



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
>

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

<div dir=3D"ltr">Boam dia...=C2=A0

<span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:1=
2.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:nor=
mal;font-weight:700;letter-spacing:normal;text-align:left;text-indent:0px;t=
ext-transform:none;white-space:nowrap;word-spacing:0px;background-color:rgb=
(255,255,255);text-decoration-style:initial;text-decoration-color:initial;f=
loat:none;display:inline">Rog=C3=A9rio Martins</span>=C2=A0<div><br></div><=
div>Eu usaria isso... faz o mesmo resultado.... ou o campo tem que ser guar=
dado na tabela?=C2=A0=C2=A0<br><div><br></div><div>

<div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12=
.8px;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">=
select</div><div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;=
font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-varia=
nt-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-=
indent:0px;text-transform:none;white-space:normal;word-spacing:0px;backgrou=
nd-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-col=
or:initial">t.data_nascimento,</div><div style=3D"color:rgb(34,34,34);font-=
family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-lig=
atures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:norma=
l;text-align:start;text-indent:0px;text-transform:none;white-space:normal;w=
ord-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:ini=
tial;text-decoration-color:initial">

<div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-style:n=
ormal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:40=
0;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:non=
e;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-de=
coration-color:initial;font-size:12.8px;background-color:rgb(255,255,255)">=
<span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:s=
mall;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">date_part(&#39;year&#39;, age(<span style=3D"colo=
r:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:nor=
mal;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(255,255,255);text-=
decoration-style:initial;text-decoration-color:initial;float:none;display:i=
nline">t.data_nascimento</span>) ) as=C2=A0</span><span style=3D"font-size:=
12.8px">t.campo_calculado_idade</span></div></div><div style=3D"color:rgb(3=
4,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;fo=
nt-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(255,255,255);text-decora=
tion-style:initial;text-decoration-color:initial">from tabela t</div><div s=
tyle=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><br></=
div><div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-siz=
e:12.8px;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"><br></div></div></div></div><div class=3D"gmail_extra"><br><div class=
=3D"gmail_quote">Em 18 de abril de 2018 08:29, Rog=C3=A9rio Martins <span d=
ir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_blank">ro=
[email protected]</a>&gt;</span> escreveu:<br><blockquote class=3D"gmail_q=
uote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1e=
x"><div dir=3D"ltr">Bom dia pessoal !<div><br></div><div>=C3=89 poss=C3=ADv=
el 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_id=
ade,</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;font-size:small;=
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">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-si=
ze:small;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">t.data_nascimento</span>) )</span><br></div><=
div><br></div><div>N=C3=A3o quero usar view,=C2=A0 preciso desse campo na t=
abela.</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_6395109302183248341gmail_signature"><div><font size=3D"3"><span style=
=3D"line-height:24px"><a href=3D"http://ubuntucounter.geekosophical.net" ta=
rget=3D"_blank"><font face=3D"tahoma, sans-serif">The Ubuntu Counter Projec=
t - user number # 33192</font></a><br></span></font></div></div>
</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>

--883d24f220a0b2c043056a1e0dd4--

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

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KcGdici1nZXJh
bCBtYWlsaW5nIGxpc3QKcGdici1nZXJhbEBsaXN0YXMucG9zdGdyZXNxbC5vcmcuYnIKaHR0cHM6
Ly9saXN0YXMucG9zdGdyZXNxbC5vcmcuYnIvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3BnYnIt
Z2VyYWw=

--===============2642189560603153003==--