Postgres Pro
Downloads
Home   >   mailing lists

Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: MERGE vs REPLACE
Date
Msg-id c2d9e70e0511212307p2cd340fer113de21002be1e94@mail.gmail.com
Whole thread Raw
In response to Re: MERGE vs REPLACE  (Petr Jelinek <pjmodos@seznam.cz>)
Responses Re: MERGE vs REPLACE  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: MERGE vs REPLACE  (Petr Jelinek <pjmodos@seznam.cz>)
List pgsql-hackers
Tree view 
>
> And yes merge CAN be used to do REPLACE (oracle uses their dummy table
> for this, we can use the fact that FROM clause isn't required in postgres).
>

the FROM clause is required by default (starting with 8.1) unless you
change a postgresql.conf parameter.

and i don't think that idea will have any fan...


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-hackers by date:

Previous
From: Bob Ippolito
Date:
Subject: Re: PostgreSQL 8.1.0 catalog corruption
Next
From: Simon Riggs
Date:
Subject: Re: Practical error logging for very large COPY