Re: [SQL] INSERT and SELECT

On Fri, 10 Dec 1999, Nikolay Mijaylov wrote:

> As i know PgSQL support subqueryes only in Where part
subquery? ;)
No.
> > I've tried this query with PostgreSQL, but it doesn't work. Could anyone
> > explain me why and what must I do to get the same result ?
> > Query example : "INSERT INTO table VALUES (
> > (SELECT oid FROM membre WHERE email="toto@toto.com"),
> > "test");"
Try:
=> INSERT INTO table -- NO values, but
-> SELECT oid FROM membre WHERE  ... ;
it may works.

--nek;(