better way?

[Rami Chowdhury]

Ah, my apologies, I must have been getting it confused with ON UPDATE  
[things]. Thanks for correcting me.

On Tue, 11 Aug 2009 13:10:03 -0700, Matthew Woodcraft  
<matthew at woodcraft.me.uk> wrote:

> "Rami Chowdhury" <rami.chowdhury at gmail.com> writes:
>
>> IIRC Postgres has had ON DUPLICATE KEY UPDATE functionality longer than
>> MySQL...
>
> PostgreSQL does not have ON DUPLICATE KEY UPDATE.
>
> The SQL standard way to do what the OP wants is MERGE. PostgreSQL
> doesn't have that either.
>
> -M-



-- 
Rami Chowdhury
"Never attribute to malice that which can be attributed to stupidity" --  
Hanlon's Razor
408-597-7068 (US) / 07875-841-046 (UK) / 0189-245544 (BD)