Re: Sv: how to build this query ??? Please help !!! - Mailing list pgsql-sql

From Jens Hartwig
Subject Re: Sv: how to build this query ??? Please help !!!
Date
Msg-id 3A543766.B66B482C@debis.com
Whole thread Raw
In response to Re: Sv: how to build this query ??? Please help !!!  (Tod McQuillin <devin@spamcop.net>)
Responses Re: Sv: how to build this query ??? Please help !!!
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sv: how to build this query ??? Please help !!!
Next
From: Tom Lane
Date:
Subject: Re: Sv: how to build this query ??? Please help !!!