better way?

[Rami Chowdhury]

IIRC Postgres has had ON DUPLICATE KEY UPDATE functionality longer than  
MySQL...

On Tue, 11 Aug 2009 11:45:50 -0700, Pet <petshmidt at googlemail.com> wrote:

> On 11 Aug., 20:39, Kushal Kumaran <kushal.kumaran+pyt... at gmail.com>
> wrote:
>> On Tue, Aug 11, 2009 at 10:03 PM, someone<petshm... at googlemail.com>  
>> wrote:
>> > Hello,
>>
>> > I'd like to make insert into db if record not exist otherwise update.
>> > to save typing list of columns in both statements I do following
>>
>> > <snip>
>>
>> > is there better or more readable way to do it?
>>
>> Well, mysql, in particular, offers an "on duplicate key update" clause
>> that you can take a look at.  Don't know about about other databases.
>>
>> --
>> kushal
>
> Oh, forgotten to mention. It's PostGres



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