Updating Using RowType

From: "Sergio Sinuco" <sergiosinuco(at)datatraffic(dot)com(dot)co>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Updating Using RowType
Date: 2011-10-29 18:56:01
Message-ID: 003d01cc966c$67f4c2b0$37de4810$@com.co
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2011-10-30 21:33:12 Re: Updating Using RowType
Previous Message Majid Azimi 2011-10-28 23:36:12 Constraint Exclusion With PreparedStatments