Re: Help with a subselect inside a view

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Bill Moseley <moseley(at)hank(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with a subselect inside a view
Date: 2005-08-25 13:05:36
Message-ID: 20050825130536.GB15100@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 24, 2005 at 23:12:17 -0700,
Bill Moseley <moseley(at)hank(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Goodenough 2005-08-25 13:06:51 Re: Postgresql replication
Previous Message Christopher Murtagh 2005-08-25 12:47:54 Re: plpgsql return setof integer?