From: Marc Howard Zuckman <marc@fallon.classyad.com>
To: Jerome Knobl <jknobl@mandanet.ch>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Subquery problems
Date: Wed, 12 Aug 1998 07:33:19 -0400 (EDT)
Message-ID: <Pine.LNX.4.00.9808120732440.22255-100000@fallon.classyad.com> (raw)
In-Reply-To: <35D14F37.13118C6@mandanet.ch>
On Wed, 12 Aug 1998, Jerome Knobl wrote:
> Hello,
>
> I'm trying to build some subquery, and it don't works like I want.
>
> I try the following query :
>
> select distinct pseudo, (select count(ref) from questions where
> questions.refpseudo=pseudos.refold) as xxx from pseudos;
>
> That query work well on MSAccess, but I have the following error on
> postgres :
>
> ERROR: parser: parse error at or near "select"
>
> I must maybe using an other method. I'm want to optain in a simple query
> to list some name of my table pseudos and to see the number of occurency
> in the table questions.
>
> Thank. Jérôme Knöbl, Switzerland
>
>
Subqueries in the target clause are not yet implemented in v 6.3.2
Marc Zuckman
marc@fallon.classyad.com
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_ Visit The Home and Condo MarketPlace _
_ http://www.ClassyAd.com _
_ _
_ FREE basic property listings/advertisements and searches. _
_ _
_ Try our premium, yet inexpensive services for a real _
_ selling or buying edge! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marc@fallon.classyad.com, jknobl@mandanet.ch
Subject: Re: [SQL] Subquery problems
In-Reply-To: <Pine.LNX.4.00.9808120732440.22255-100000@fallon.classyad.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox