Postgres Pro
Downloads
Home   >   mailing lists

Re: Select into - Mailing list pgsql-sql

From Gavin 'Beau' Baumanis
Subject Re: Select into
Date
Msg-id 50DE8714-0EC7-432D-845B-4F8E6FE136DC@eclinic.com.au
Whole thread Raw
In response to Re: Select into  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Select into  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Tree view 
Hi Everyone,

I want to thank everyone for their help / suggestions...
I really appreciate it.

Though I think I have found a winner.

> craig=# update x set val = foundrow.val from ( select val from x  
> where id = 2 ) as foundrow where id = 1 ;
> UPDATE 1
>

Very elegant, very clean...
Very nice!

Thanks!!!!

pgsql-sql by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: Select into
Next
From: Craig Ringer
Date:
Subject: Re: Select into