Re: Select in update

From: Holger Klawitter <holger(at)klawitter(dot)de>
To: "Joco" Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br>
Cc: postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Select in update
Date: 2002-07-09 11:05:10
Message-ID: 200207091225.29806.holger@klawitter.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Is it possible?? Can I use a select statement as input
> for an update??

With 7.2.1, no problem. But you have to think about what happens
if the select returns more then one tuple (errr row :-) as this
will result in an error.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Curt Sampson 2002-07-09 11:15:31 Re: I am being interviewed by OReilly
Previous Message Richard Huxton 2002-07-09 10:52:29 Re: Query Casting Help