Re: update question - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: update question
Date
Msg-id c2d9e70e0512051508y2a9c4addj5c7927f3f4052775@mail.gmail.com
Whole thread Raw
In response to update question  (Matthew Peter <survivedsushi@yahoo.com>)
Responses Re: update question  (Matthew Peter <survivedsushi@yahoo.com>)
Re: update question  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-sql
On 12/5/05, Matthew Peter <survivedsushi@yahoo.com> wrote:
> I need a throw away value for an insert statement... example...
>
> update table
> set value = 1, value = 2, throw_away_value -- so i don't break the query
> where id = 1;
>
> Thanks
>

What do you mean by "throw away value"?

are you trying to update and if the row doesn't exist then insert? if
that is you can do a function in plpgsql and use exceptions for
that... there is an example in the manuals

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


pgsql-sql by date:

Previous
From: Matthew Peter
Date:
Subject: update question
Next
From: Matthew Peter
Date:
Subject: Re: update question