X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B7DC49DCCDD for ; Mon, 5 Dec 2005 18:59:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68416-06 for ; Mon, 5 Dec 2005 18:59:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web35212.mail.mud.yahoo.com (web35212.mail.mud.yahoo.com [66.163.179.91]) by postgresql.org (Postfix) with SMTP id 167E19DCCB0 for ; Mon, 5 Dec 2005 18:59:33 -0400 (AST) Received: (qmail 46342 invoked by uid 60001); 5 Dec 2005 22:59:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=3nKtnrkTrmHPABOTtrhotGX1tal4oqZn3EctF9MOOvpNxlxTAyMhi0B8qp3Wbfv2uy7wbPnRHnfugblysxI0rZxrQ1n5TfqMKRFarVgBoOsYhql5+85z8lQMU+15e0WKiwW0hLUWRX92g+ePyEbbTRx8JJQW5yIPjUNMHPn/q2Q= ; Message-ID: <20051205225936.46340.qmail@web35212.mail.mud.yahoo.com> Received: from [70.104.144.58] by web35212.mail.mud.yahoo.com via HTTP; Mon, 05 Dec 2005 14:59:35 PST Date: Mon, 5 Dec 2005 14:59:35 -0800 (PST) From: Matthew Peter Subject: update question To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-170403304-1133823575=:44153" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200512/28 X-Sequence-Number: 23570 --0-170403304-1133823575=:44153 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --------------------------------- Yahoo! Personals Let fate take it's course directly to your email. See who's waiting for you Yahoo! Personals --0-170403304-1133823575=:44153 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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


Yahoo! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals --0-170403304-1133823575=:44153--