Re: Sv: how to build this query ??? Please help !!!

Поиск
Список
Период
Сортировка
От Jens Hartwig
Тема Re: Sv: how to build this query ??? Please help !!!
Дата
Msg-id 3A543766.B66B482C@debis.com
обсуждение исходный текст
Ответ на Re: Sv: how to build this query ??? Please help !!!  (Tod McQuillin <devin@spamcop.net>)
Ответы Re: Sv: how to build this query ??? Please help !!!
Список pgsql-sql
> [...]
> Subqueries are covered in Bruce Momjian's book:
> http://www.postgresql.org/docs/aw_pgsql_book/node93.html
> [...]

Thanks for the information, but Bruce (which I have already read) and
all other docs I´ve seen "only" mention normal subselects. I know
subselects (what a poor database engineer I would be otherwise ;-)) but
I have never seen a statement like

SELECT a, (SELECT b) 
FROM xyz;

IMHO this is no normal subselect and it does not correlate with the
SQL-standard. Is it a trick?

Best regards, Jens

=============================================
Jens Hartwig
---------------------------------------------
debis Systemhaus GEI mbH
10875 Berlin
Tel.     : +49 (0)30 2554-3282
Fax      : +49 (0)30 2554-3187
Mobil    : +49 (0)170 167-2648
E-Mail   : jhartwig@debis.com
=============================================


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sv: how to build this query ??? Please help !!!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sv: how to build this query ??? Please help !!!