Re: Updating Using RowType - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Updating Using RowType
Date
Msg-id CAHyXU0wQ1XY=hzj4c1O688Tiz_hWb9283vkjOv_xgopypzsFMw@mail.gmail.com
Whole thread Raw
In response to Updating Using RowType  ("Sergio Sinuco" <sergiosinuco@datatraffic.com.co>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Sergio Sinuco"
Date:
Subject: Updating Using RowType
Next
From: "Ludger Sonntag"
Date:
Subject: execute sql-script several times