Re: selects possible in VALUES() claueses?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Gearon <gearond(at)cvc(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selects possible in VALUES() claueses?
Date: 2003-03-03 04:13:57
Message-ID: 20030303041357.GA5009@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 02, 2003 at 19:05:15 -0800,
Dennis Gearon <gearond(at)cvc(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2003-03-03 04:34:23 ALTER SEQUENCE
Previous Message Martijn van Oosterhout 2003-03-03 04:04:58 Re: selects possible in VALUES() claueses?