Skip site navigation (1) Skip section navigation (2)

Re: have you seen this?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: robert(dot)bernier5(at)sympatico(dot)ca, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: have you seen this?
Date: 2004-05-24 14:17:37
Message-ID: 40B20401.3080208@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
Martin Marques wrote:

> El Sáb 22 May 2004 20:00, Robert Bernier escribió:
>> http://det-dbalice.if.pw.edu.pl/det-dbalice/ttraczyk/db_compare/db_compare.
>>html
> 
> I don't know when they wrote this but...:
> 
> 
> Subqueries in FROM clause
> 
>  Possibility of using subquery (nested query) in FROM clause of SQL query. 
> 
> MySQL:
> No. Will be added in next versions.
> 
> Oracle8:
> Yes.
> 
> Postgres:
> No. The feature will be supported from version 7.1. 
> 
> 
> When was 7.1 released? 2001?

Yeah, and funny enough, it's still "to be" included in the next version 
of MySQL ... and what they have so far for 4.1 (in the 4.1.1 Alpha) is 
one implementation of subselects for the FROM clause and apparently 
another one for the WHERE clase (this is an assumption based on the fact 
that subselects support different language features if they are in the 
FROM clause or the WHERE clause). Fortunately I don't have to maintain 
any of that code.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #


In response to

Responses

pgsql-advocacy by date

Next:From: Elein MustainDate: 2004-05-24 14:26:13
Subject: Re: have you seen this?
Previous:From: Ned LillyDate: 2004-05-24 14:08:49
Subject: MySQL Lays Path for SAP Integration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group