Re: Postgres8: subselect and optimizer/planner

Erwin Moller wrote:
>
> SELECT U.userid, U.username,
> (SELECT G.groupname FROM tblgroup WHERE (G.userid=U.userid)) AS ingroup

typo, that should be 'tblgroup as G' of course.

> FROM tbluser WHERE (bla..bla...);


-------------------
Erwin Moller
Darwine BV

Groenendaal 25f
3011 SK Rotterdam
tel 010-2133996
-------------------