On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> 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 ;) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org