Обсуждение: update question
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
update table
set value = 1, value = 2, throw_away_value -- so i don't break the query
where id = 1;
Thanks
Yahoo! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals
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 ;)
it's in a loop so there's an extra comma at the end so i was thinking i could put in a throw away value to keep the update from breaking if there's an additional comma
Jaime Casanova <systemguards@gmail.com> wrote:
Jaime Casanova <systemguards@gmail.com> wrote:
On 12/5/05, Matthew Peter 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
Yahoo! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Yahoo! Personals
Like WHERE 1 = 1, but in UPDATE table SET value = 1, 1 = 1;
Yahoo! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Try Yahoo! Personals
On 12/5/05, Matthew Peter <survivedsushi@yahoo.com> wrote: > it's in a loop so there's an extra comma at the end so i was thinking i > could put in a throw away value to keep the update from breaking if there's > an additional comma > > Jaime Casanova <systemguards@gmail.com> wrote: > On 12/5/05, Matthew Peter 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 > > > i guess you are constructing the query in a string and EXECUTEd it... if that is the case review your logic... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
Matthew Peter <survivedsushi@yahoo.com> writes:
> it's in a loop so there's an extra comma at the end so i was thinking i could put in a throw away value to keep the
updatefrom breaking if there's an additional comma
The best thing is to fix your loop logic. Usually it's not hard to emit
a comma only if one is needed.
If you're intent on using a broken loop, you could do "foo = foo" where
foo is any table column you didn't yet assign to. Consider though the
corner case where you've already assigned all the columns. Best bet
is to fix your loop...
regards, tom lane