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

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

pgsql-hackers by date

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

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