Home > mailing lists

Re: sub-selects - Mailing list pgsql-sql

From	PFC
Subject	Re: sub-selects
Date	May 16, 2005 20:36:05
Msg-id	op.sqvx6byjth1vuj@localhost Whole thread Raw
In response to	sub-selects ("Mark Fenbers" <Mark.Fenbers@noaa.gov>)
List	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

?

From: "Mark Fenbers"
Date: 16 May 2005, 19:45:57
Subject: sub-selects

From: "Joel Fradkin"
Date: 16 May 2005, 21:35:59
Subject: getting duplicate number is there a