Skip site navigation (1) Skip section navigation (2)

Update Syntax

From: ramirez(at)idconcepts(dot)org (Edwin S(dot) Ramirez)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Update Syntax
Date: 2004-01-30 15:41:18
Message-ID: 8d9c3e20.0401300741.8c287d3@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 statements are the only ones supported by Oracle
to update one table from another.

Can this be added to the TODO list?
Can a cash prize be associated with the TODO item?, I have $1000US
allocated for this.

-ESR-

Responses

pgsql-hackers by date

Next:From: Edwin S. RamirezDate: 2004-01-30 15:43:06
Subject: Transaction aborts on syntax error.
Previous:From: Tom LaneDate: 2004-01-30 15:39:46
Subject: Re: Question about indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group