Re: Updating Using RowType

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Sergio Sinuco <sergiosinuco(at)datatraffic(dot)com(dot)co>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Updating Using RowType
Date: 2011-10-30 21:33:12
Message-ID: CAHyXU0wQ1XY=hzj4c1O688Tiz_hWb9283vkjOv_xgopypzsFMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Oct 29, 2011 at 2:56 PM, Sergio Sinuco
<sergiosinuco(at)datatraffic(dot)com(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ludger Sonntag 2011-10-31 16:22:58 execute sql-script several times
Previous Message Sergio Sinuco 2011-10-29 18:56:01 Updating Using RowType