Re: MySQL update

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MySQL update
Date: 2002-12-04 14:37:47
Message-ID: 1039012667.2271.2.camel@rh72.home.ee
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marc G. Fournier kirjutas K, 04.12.2002 kell 18:57:
> On Tue, 3 Dec 2002, Christopher Kings-Lynne wrote:
>
> > Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it
> > now has subselects.

Any idea _where_ you can use them ?

i.e.is it

select a, (select b from tb) from ta;

or is it

select a from (select a from tb) as ta;

or something else.

Also, can one have correlated subqueries

select a, (select b from tb where a=ta.a) from ta;

-------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Berndtsson 2002-12-04 15:38:37 big text field -> message type 0x44
Previous Message Dan Langille 2002-12-04 14:33:08 Re: The Web Sites (Was: Re: [HACKERS] [GENERAL] PostgreSQL Gl...)