Case - Postgers

---

select empresa,codigo,nome,
case
when codigo_fluxo=1 then 'Codigo 1'
when codigo_fluxo=2 then 'Codigo 2'
else 'codigo fluxo nao existe'
end
from cliente
order by codigo_fluxo;

Curso Postgres - Inicio - Aula 1 e Aula 2

---

Aula 1
Site Postgres http://www.postgresql.org/
Autor : Rafael Silva

---

Aula 2
cmd
net user postgers /delete
delete usuario
. create dabase teste;
. \connect teste postgres;
. \d
mostra tabela
. create table clientes(id integer, nome varchar);
. create sequence id;
. drop sequence id;
. select version();

---