Postgres Pro
Downloads
Home   >   mailing lists

Re: Select in update - Mailing list pgsql-general

From Holger Klawitter
Subject Re: Select in update
Date
Msg-id 200207091225.29806.holger@klawitter.de
Whole thread Raw
In response to Select in update  ("João" Paulo Batistella <batistellabr@yahoo.com.br>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: "Yvan Blancmunier"
Date:
Subject: performances mysql ???
Next
From: s.chava@wcom.com (Srinivasa Rao Chava)
Date:
Subject: Problem with postgresql 7.2.1