Re: Postgres8: subselect and optimizer/planner

From: Erwin Moller <erwin(at)darwine(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres8: subselect and optimizer/planner
Date: 2007-10-04 10:01:47
Message-ID: 4704BA0B.1010902@darwine.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
-------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-10-04 10:09:38 Re: Design Question (Time Series Data)
Previous Message Erwin Moller 2007-10-04 09:52:36 Postgres8: subselect and optimizer/planner