Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres8: subselect and optimizer/planner - Mailing list pgsql-general

From Erwin Moller
Subject Re: Postgres8: subselect and optimizer/planner
Date
Msg-id 4704BA0B.1010902@darwine.nl
Whole thread Raw
In response to Postgres8: subselect and optimizer/planner  (Erwin Moller <erwin@darwine.nl>)
List pgsql-general
Tree view 
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
-------------------

pgsql-general by date:

Previous
From: Erwin Moller
Date:
Subject: Postgres8: subselect and optimizer/planner
Next
From: "Pavel Stehule"
Date:
Subject: Re: Design Question (Time Series Data)