From: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
---|---|
To: | pgsql-sql(at)hub(dot)org |
Subject: | PostgreSQL syntax question |
Date: | 1998-09-18 05:07:28 |
Message-ID: | 199809180507.OAA32277@mustang.sdc.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
The following syntax (which is legal under Oracle) does not parse under
PostreSQL 6.3.2.
update table1 set col1=(select col2 from table2 where col3='x') where col4='z';
Is there a variant of the syntax which does work?
Cheers and thanks,
Stephen.
========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-09-18 05:14:45 | Re: [HACKERS] pg_user backtrace -- with ElectricFence (looks useful :) |
Previous Message | Bruce Momjian | 1998-09-18 04:47:50 | Re: [HACKERS] oid8types() borken? |
From | Date | Subject | |
---|---|---|---|
Next Message | William Leeke | 1998-09-18 06:39:21 | SQL equiv to MS-Access Transform |
Previous Message | Bruce Momjian | 1998-09-18 02:58:51 | Re: [SQL] postmaster dies on complicated views |