Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 82FD29FA372 for ; Mon, 6 Nov 2006 15:22:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 38235-05 for ; Mon, 6 Nov 2006 19:22:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0F5DC9FA103 for ; Mon, 6 Nov 2006 15:22:02 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kA6JLxt8028862; Mon, 6 Nov 2006 14:21:59 -0500 (EST) To: hubert.retif@i-netsoft.ch cc: pgsql-sql@postgresql.org Subject: Re: Nested select In-reply-to: <200611061136.kA6BahZc012041@saturn11.saturn11.de> References: <200611061136.kA6BahZc012041@saturn11.saturn11.de> Comments: In-reply-to =?us-ascii?Q?Hubert_Retif?= message dated "Mon, 06 Nov 2006 12:08:36 +0100" Date: Mon, 06 Nov 2006 14:21:59 -0500 Message-ID: <28861.1162840919@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/79 X-Sequence-Number: 26731 =?us-ascii?Q?Hubert_Retif?= writes: > I am migrating my application from MySQL to Postgresql and have met > following situation: > ... > works perfectly in MySQL, but not in Postgresql. If you want useful help, you need to explain exactly what results you got and what you expected to get. "Works perfectly" is content-free. regards, tom lane