Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with a subselect inside a view - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Help with a subselect inside a view
Date
Msg-id 20050825130536.GB15100@wolff.to
Whole thread Raw
In response to Help with a subselect inside a view  (Bill Moseley <moseley@hank.org>)
Responses Re: Help with a subselect inside a view  (Bill Moseley <moseley@hank.org>)
List pgsql-general
Tree view 
On Wed, Aug 24, 2005 at 23:12:17 -0700,
  Bill Moseley <moseley@hank.org> wrote:
> I need a little SQL help:
>
> I'm trying to get a subselect working inside a view.

Unfortunately you didn't show us what you tried. My guess would be that
you didn't enclose the subselect in parenthesis.

The distinct on solution that was suggested is probably a better way to
go anyway.

pgsql-general by date:

Previous
From: Christopher Murtagh
Date:
Subject: Re: plpgsql return setof integer?
Next
From: David Goodenough
Date:
Subject: Re: Postgresql replication