| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Petr Jelinek <pjmodos(at)seznam(dot)cz> |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: MERGE vs REPLACE |
| Date: | 2005-11-22 07:07:48 |
| Message-ID: | c2d9e70e0511212307p2cd340fer113de21002be1e94@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> 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 ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-11-22 08:07:08 | Re: Practical error logging for very large COPY |
| Previous Message | Bob Ippolito | 2005-11-22 04:17:39 | Re: PostgreSQL 8.1.0 catalog corruption |