is any reason why we cannot cast from record (row) to typed row?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: is any reason why we cannot cast from record (row) to typed row?
Date: 2010-01-21 07:28:55
Message-ID: 162867791001202328i746a0fb0u44f76944d94b97b4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I looked on question on
http://stackoverflow.com/questions/2104811/execute-using-statement-in-pl-pgsql-doesnt-work-with-record-type

I was surprised so isn't possible cast from record to target type - is
there reason for this?

DECLARE r RECORD;
BEGIN
EXECUTE 'SELECT * FROM xx' INTO r;

r::xx isn't possible
r::text::xx is possible

Regards
Pavel Stehule

Browse pgsql-hackers by date

  From Date Subject
Next Message Takahiro Itagaki 2010-01-21 07:52:25 Re: Largeobject Access Controls (r2460)
Previous Message Heikki Linnakangas 2010-01-21 07:27:58 Re: HS/SR and smart shutdown