On Fri, Jan 30, 2004 at 07:41:18 -0800,
"Edwin S. Ramirez" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need Postgres support for the following update syntax :
>
> update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
> where id=5) where rownum=3;
>
> update table1 set (col1, col2
Hello,
I need Postgres support for the following update syntax :
update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
where id=5) where rownum=3;
update table1 set (col1, col2, col3) = (select f1, f2, f3 from table2
where id=table1.parentid) where rownum=3;
These type of update
Hello,
Are update statements like:
update t1 set (f1, f2, f3) = (select t1, t2, t3 from tab1 where id=5) where id=3
standard. Any hope of supporting this in Postgres?
-Edwin S. Ramirez-
---(end of broadcast)---
TIP 9: the planner will ignore yo
