Re: AS operator and subselect result names: PostgreSQL

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Neil Zanella <nzanella(at)cs(dot)mun(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: AS operator and subselect result names: PostgreSQL
Date: 2003-11-02 21:10:27
Message-ID: Pine.LNX.4.44.0311022209580.1528-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2003-11-02 21:31:42 Re: retrieve statement from catalogs
Previous Message mlunnon @ RWA 2003-11-02 21:02:42 Re: Custom types and arrays