Re: [SQL] PostgreSQL syntax question

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. |

In response to

Browse pgsql-hackers by date

  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

Browse pgsql-sql by date

  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