Postgres Pro
Downloads
Home   >   mailing lists

Re: Select into - Mailing list pgsql-sql

From Gurjeet Singh
Subject Re: Select into
Date
Msg-id 65937bea0803200514o5bc8e244x27b94db1f0feb31f@mail.gmail.com
Whole thread Raw
In response to Re: Select into  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Tree view
On Thu, Mar 20, 2008 at 5:35 PM, Craig Ringer <craig@postnewspapers.com.au> wrote:

craig=# explain update x set val = foundrow.val from ( select val from x
where id = 4123 ) as foundrow where id = 5912 ;

Thats nifty.
 


--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device

pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Select into
Next
From: Gavin 'Beau' Baumanis
Date:
Subject: Re: Select into