AS operator and subselect result names: PostgreSQL vs. Oracle

From: nzanella(at)cs(dot)mun(dot)ca (Neil Zanella)
To: pgsql-general(at)postgresql(dot)org
Subject: AS operator and subselect result names: PostgreSQL vs. Oracle
Date: 2003-11-01 04:44:19
Message-ID: b68d2f19.0310312044.3c98da8d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to ask the about the following...

PostgreSQL allows tables resulting from subselects to be renamed with
an optional AS keyword whereas Oracle 9 will report an error whenever
a table is renamed with the AS keyword. Furthermore, in PostgreSQL
when the result of a subselect is referenced in an outer select
it is required that the subselect result be named, whereas this
is not true in Oracle. I wonder what standard SQL has to say
about these two issues. In particular:

1. Does standard SQL allow an optional AS keyword for (re/)naming
tables including those resulting from subselects.

and

2 Why must a subselect whose fields are referenced in an outer query
be explicitly named in PostgreSQL when it is not necessary in Oracle.

Thanks,

Neil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-11-01 04:56:56 Re: 7.3.5 release (was: Re: SELECT with row>32k hangs over
Previous Message Ryan Mack 2003-11-01 01:36:21 PostgreSQL License Question