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(at)postgresql(dot)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).