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

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

pgsql-novice by date

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

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