Postgres Pro
Downloads
Home   >   mailing lists

Thread: Updating Using RowType

Updating Using RowType

From
"Sergio Sinuco"
Date:

Is it possible to UPDATE data into a table using a rowtype data type? I had found:

 

l_updated_cd cds%ROWTYPE;

UPDATE cds SET ROW = l_updated_cd WHERE album_name = ‘The Future’,

 

But, it doesn’t work.

 

Any ideas?

 

Thanks for your help,

Sergio.

Re: Updating Using RowType

From
Merlin Moncure
Date:
On Sat, Oct 29, 2011 at 2:56 PM, Sergio Sinuco
<sergiosinuco@datatraffic.com.co> wrote:
> Is it possible to UPDATE data into a table using a rowtype data type? I had
> found:
>
>
>
> l_updated_cd cds%ROWTYPE;
>
> UPDATE cds SET ROW = l_updated_cd WHERE album_name = ‘The Future’,

this is unfortunately impossible.  inserts can be rigged, but not updates.

merlin