Received: from fallon.classyad.com (root@classyad.com [152.160.43.1]) by
	hub.org (8.8.8/8.7.5) with ESMTP id HAA25710 for
	<pgsql-sql@postgreSQL.org>; Wed, 12 Aug 1998 07:33:40 -0400 (EDT)
Received: from localhost (IDENT:marc@localhost [127.0.0.1] (may be forged))
	by fallon.classyad.com (8.9.0/8.9.0) with SMTP id HAA22528;
	Wed, 12 Aug 1998 07:33:19 -0400
Date: Wed, 12 Aug 1998 07:33:19 -0400 (EDT)
From: Marc Howard Zuckman <marc@fallon.classyad.com>
To: Jerome Knobl <jknobl@mandanet.ch>
cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Subquery problems
In-Reply-To: <35D14F37.13118C6@mandanet.ch>
Message-ID: <Pine.LNX.4.00.9808120732440.22255-100000@fallon.classyad.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=X-UNKNOWN
Content-Transfer-Encoding: QUOTED-PRINTABLE


On Wed, 12 Aug 1998, Jerome Knobl wrote:

> Hello,
>=20
> I'm trying to build some subquery, and it don't works like I want.
>=20
> I try the following query :
>=20
> select distinct pseudo, (select count(ref) from questions where
> questions.refpseudo=3Dpseudos.refold) as xxx from pseudos;
>=20
> That query work well on MSAccess, but I have the following error on
> postgres :
>=20
> ERROR:  parser: parse error at or near "select"
>=20
> 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.
>=20
> Thank. J=E9r=F4me Kn=F6bl, Switzerland
>=20
>=20
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=09=09      _
_          http://www.ClassyAd.com=09=09=09      _
_=09=09=09=09=09=09=09      _
_  FREE basic property listings/advertisements and searches.  _
_=09=09=09=09=09=09=09      _
_  Try our premium, yet inexpensive services for a real=09      _
_   selling or buying edge!=09=09=09=09      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_