Postgres Pro
Downloads
Home   >   mailing lists

Re: AS operator and subselect result names: PostgreSQL - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: AS operator and subselect result names: PostgreSQL
Date
Msg-id Pine.LNX.4.44.0311022209580.1528-100000@peter.localdomain
Whole thread Raw
In response to AS operator and subselect result names: PostgreSQL vs. Oracle  (nzanella@cs.mun.ca (Neil Zanella))
List pgsql-general
Tree view 
Neil Zanella writes:

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

Yes.

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

Because the SQL standard says so.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: "mlunnon @ RWA"
Date:
Subject: Re: Custom types and arrays
Next
From: "Jaime Casanova"
Date:
Subject: Re: retrieve statement from catalogs