Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group