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(at)toto(dot)com"),
> > "test");"
Try:
=> INSERT INTO table
-- NO values, but
-> SELECT oid FROM membre WHERE ... ;
it may works.
--
nek;(