Re: Selecting Fields in Union in Subquery

2012/7/13 Tom Burns <tramseyburns(at)yahoo(dot)com>

>
> I can no figure out the syntax for directly addressing fields (for example
> 'order by StateProvence" or "order by gTo.geo_name" instead of order by 3)
>

This should work ("StateProvence" not gTo.geo_name), but You should
remember to use " (quotation mark) when You use camel cased names. If not
PG will treat fields names like written in small letters.
You should do something like this:
order by "StateProvence"
not
order by StateProvence

> I would like to be able to filter and sort the sub-query in the parent
> query.
>
I don't get it, I assume You would like to sort/filter sub-query *result* in
parent query. Then You should remember to use names of sub-query result
columns i.e
gTo.geo_name is not visilbe, but geolist."StateProvence" is visible outside
sub query

Regards,
Bartek