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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Is it possible to UPDATE data into a table using a rowtype data type? I had


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,



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-2017 The PostgreSQL Global Development Group