Re: Inheritance c.cities ??

R Talbot wrote:
>
> Looking at the Postgresql manual in the inheritance section I see
> abbreviations.
>
> i.e.
> SELECT c.name, c.altitude
> FROM cities* c
> WHERE c.altitude > 500;
>
> c.name  of course refering to cities.name
>  My question is where is there an alias reference of  c AS cities
>
> How does and where does the  cities become c.  How does Postgresql
> recognize the change.


FROM cities* c is the same as
FROM cities* AS c
I personally would prefer it if everyone used the AS when it is implied
as, IMHO, it makes such statements much clearer.


>
> bob T
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
This is the identity that I use for NewsGroups. Email to
this will just sit there. If you wish to email me replace
the domain with knightpiesold . co . uk (no spaces).