Re: update question

<div id="RTEContent">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
valueto keep the update from breaking if there's an additional comma<br /><br /><b><i>Jaime Casanova
<systemguards@gmail.com></i></b>wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255);
margin-left:5px; padding-left: 5px;"> On 12/5/05, Matthew Peter  wrote:<br />> I need a throw away value for an
insertstatement... example...<br />><br />> update table<br />> set value = 1, value = 2, throw_away_value --
soi don't break the query<br />> where id = 1;<br />><br />> Thanks<br />><br /><br />What do you mean by
"throwaway value"?<br /><br />are you trying to update and if the row doesn't exist then insert? if<br />that is you
cando a function in plpgsql and use exceptions for<br />that... there is an example in the manuals<br /><br />--<br
/>regards,<br/>Jaime Casanova<br />(DBA: DataBase Aniquilator ;)<br /><br />---------------------------(end of
broadcast)---------------------------<br/>TIP 4: Have you searched our list archives?<br /><br />
http://archives.postgresql.org<br/></blockquote><br /></div><p><hr size="1" /><b>Yahoo! Personals</b><br /> Single?
There'ssomeone we'd like you to meet.<br /> Lots of someones, actually. <a
href="http://us.rd.yahoo.com/evt=36108/*http://personals.yahoo.com
 
">Yahoo! Personals</a>