Re: selects possible in VALUES() claueses? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: selects possible in VALUES() claueses?
Date
Msg-id 20030303041357.GA5009@wolff.to
Whole thread Raw
In response to selects possible in VALUES() claueses?  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Sun, Mar 02, 2003 at 19:05:15 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> Is it possible to do this?

Yes but you need to use 'select' instead of 'values' the query should
return the constant strings in addition to gen_id. My guess is that
you might want a limit 1 in there too so that only one gen_id is
returned.

pgsql-general by date:

Previous
From: bob parker
Date:
Subject: Re: Was 26 votes - now still need 10
Next
From: Martijn van Oosterhout
Date:
Subject: Re: selects possible in VALUES() claueses?