Re: sub-selects

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Mark Fenbers" <Mark(dot)Fenbers(at)noaa(dot)gov>, pgsql-sql(at)postgresql(dot)org
Subject: Re: sub-selects
Date: 2005-05-16 20:36:01
Message-ID: op.sqvx6byjth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


SELECT foo.*, npoints( foo.g )
FROM
(SELECT a, (select b from c where d = e limit 1) AS g FROM f WHERE
isValid( g ))
AS foo

?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Fradkin 2005-05-16 21:36:21 getting duplicate number is there a
Previous Message Mark Fenbers 2005-05-16 19:45:43 sub-selects