select in update - Mailing list pgsql-sql

From Engard Ferenc
Subject select in update
Date
Msg-id Pine.LNX.3.96.981124003803.1032D-100000@Pons.sote.hu
Whole thread Raw
Responses Re: [SQL] select in update
List pgsql-sql
Hi all,

Yet another question: (quite busy today... :)

oeptest=> update shorttest2 set b=(select b from shorttest t1 where t1.a=1) where a=2;
ERROR:  parser: parse error at or near "select"

It means that the subquery in update is not implemented? And if it isn't,
how can I evade it? Maybe select ... into .., but it's not a good idea in a
big table... :(((

Any help?

Thx a lot:
Circum

 __  @
/  \    _   _                                           Engard Ferenc
l    | ( \ /  | | (\/)                      mailto:s-fery@kkt.sote.hu
\__/ | |   \_ \_/ I  I                    http://pons.sote.hu/~s-fery


pgsql-sql by date:

Previous
From: Engard Ferenc
Date:
Subject: cursor and update + view
Next
From: pierre
Date:
Subject: MINUS and slow 'not in'