Subquery problems

Jérome Knöbl <jknobl@mandanet.ch>

From: Jerome Knobl <jknobl@mandanet.ch>
To: pgsql-sql@postgresql.org
Date: 1998-08-12T08:15:52Z
Lists: pgsql-sql
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