SELECT TOP 1 bco_codigo
FROM Banco
WHERE bco_codigo = '001'
IF FOUND THEN
INSERT INTO Banco
(bco_codigo,
bco_nome)
VALUES
('001',
'Banco do Brasil')
ELSE
UPDATE Banco
SET bco_codigo = '001',
bco_nome = 'BB - Banco do Brasil SA '
WHERE bco_codigo = '001'
END IF;
On 8/27/07, nigelky <[EMAIL PROTECTED]> wrote:
>
>
> Olá a todos!
> como faço o seguinte comando do sql server, no postgresql?
>
> IF NOT EXISTS (SELECT TOP 1 bco_codigo
> FROM Banco
> WHERE bco_codigo = '001')
> BEGIN
> INSERT INTO Banco
> (bco_codigo,
> bco_nome)
> VALUES
> ('001',
> 'Banco do Brasil')
> END
> ELSE
> BEGIN
> UPDATE Banco
> SET bco_codigo = '001',
> bco_nome = 'BB - Banco do Brasil SA '
> WHERE bco_codigo = '001'
> END
>
>
> --
> View this message in context:
> http://www.nabble.com/D%C3%BAvida-SQL-Server-X-PostgreSQL%3A-IF-NOT-EXISTS-tf4337653.html#a12355603
> Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
--
Att,
Leonardo Chaves de Freitas
QualiConsult
Analista de Bando de Dados - DBA
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
