[pgbr-geral] Dúvida SQL Server X PostgreSQL: IF NOT EXISTS

Mon, 27 Aug 2007 15:24:55 -0700 

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
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a