From: | Marc Howard Zuckman <marc(at)fallon(dot)classyad(dot)com> |
---|---|
To: | Jerome Knobl <jknobl(at)mandanet(dot)ch> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Subquery problems |
Date: | 1998-08-12 11:33:19 |
Message-ID: | Pine.LNX.4.00.9808120732440.22255-100000@fallon.classyad.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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. Jrme Knbl, Switzerland
>
>
Subqueries in the target clause are not yet implemented in v 6.3.2
Marc Zuckman
marc(at)fallon(dot)classyad(dot)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! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-08-12 12:25:39 | Re: [SQL] Query based on date/time field |
Previous Message | Jerome Knobl | 1998-08-12 08:15:52 | Subquery problems |