| From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | "Gavin 'Beau' Baumanis" <gavinb(at)eclinic(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Subject: | Re: Select into |
| Date: | 2008-03-20 12:14:23 |
| Message-ID: | 65937bea0803200514o5bc8e244x27b94db1f0feb31f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Mar 20, 2008 at 5:35 PM, Craig Ringer <craig(at)postnewspapers(dot)com(dot)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[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ 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
Mail sent from my BlackLaptop device
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin 'Beau' Baumanis | 2008-03-20 12:20:27 | Re: Select into |
| Previous Message | Joe | 2008-03-20 12:10:47 | Re: Select into |