From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | sferac(at)bo(dot)nettuno(dot)it |
Cc: | pgsql-sql(at)hub(dot)org, scldad(at)sdc(dot)com(dot)au, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [SQL] PostgreSQL syntax question |
Date: | 1998-09-18 16:21:38 |
Message-ID: | 199809181621.MAA02293@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
> SD> The following syntax (which is legal under Oracle) does not parse under
> SD> PostreSQL 6.3.2.
>
> SD> update table1 set col1=(select col2 from table2 where col3='x') where col4='z';
> This syntax is SQL standard but seems that PostgreSQL doesn't
> support "scalar subqueries" yet.
> I don't see this on TODO things ? What about to add it to TODO file ?
Already there:
* Allow subqueries in target list
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle | (610) 353-9879(w)
+ If your life is a hard drive, | (610) 853-3000(h)
+ Christ can be your backup. |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-09-18 16:48:41 | Re: [HACKERS] PL/pgsql |
Previous Message | David Hartwig | 1998-09-18 14:44:33 | PL/pgsql |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-09-18 17:29:54 | Re: [SQL] Turn autocommit off ? |
Previous Message | Sferacarta Software | 1998-09-18 13:13:37 | Re: [SQL] PostgreSQL syntax question |