Re: Selecting Fields in Union in Subquery
| От | Bartosz Dmytrak |
|---|---|
| Тема | Re: Selecting Fields in Union in Subquery |
| Дата | |
| Msg-id | CAD8_UcYdP6wHjkciNAh8ZSRVWF8d-n9hVEL8-G472qj94hkrkw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Selecting Fields in Union in Subquery (Tom Burns <tramseyburns@yahoo.com>) |
| Список | pgsql-novice |
2012/7/13 Tom Burns <tramseyburns@yahoo.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
В списке pgsql-novice по дате отправления: