Re: MERGE vs REPLACE

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 ;)

In response to

Responses

Browse pgsql-hackers by date

  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