Received: from neptun.sns-felb.debis.de (neptun.sns-felb.debis.de [53.122.101.2]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f048fv773591 for ; Thu, 4 Jan 2001 03:41:57 -0500 (EST) (envelope-from jhartwig@debis.com) Received: by neptun.sns-felb.debis.de; id JAA06359; Thu, 4 Jan 2001 09:47:02 +0100 Received: from unknown(53.113.82.10) by neptun.sns-felb.debis.de via smap (V5.0) id xma006333; Thu, 4 Jan 01 09:46:52 +0100 Received: from mail1.b3.dsh.de (localhost [127.0.0.1]) by dshmail1.dsh.de (8.9.1/8.8.7) with ESMTP id JAA05353; Thu, 4 Jan 2001 09:44:47 +0100 (MET) Received: from debis.com ([138.201.143.121]) by mail1.b3.dsh.de (8.10.0/8.10.0) with ESMTP id f048gG510355; Thu, 4 Jan 2001 09:42:16 +0100 Message-ID: <3A543766.B66B482C@debis.com> Date: Thu, 04 Jan 2001 09:42:14 +0100 From: Jens Hartwig Organization: debis Systemhaus GEI X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de MIME-Version: 1.0 To: Tod McQuillin CC: Nikolaj Lundsgaard , pgsql-sql@postgresql.org Subject: Re: Sv: how to build this query ??? Please help !!! References: Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/47 X-Sequence-Number: 708 > [...] > 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 =============================================