Question about anyelement datatype

From: Kaarel <krl(at)klaabu(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about anyelement datatype
Date: 2008-11-25 23:24:18
Message-ID: 492C8922.3060006@klaabu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I need to use the following statement in a stored procedure:

EXECUTE 'SELECT * FROM ' || v_table_name INTO v_result;

where v_table_name and v_result are the arguments of the function.
v_table_name is of character varying type and v_result is anyelement.

But as I discovered, it's not allowed to write into function arguments.
I also tried to declare v_result like this:

v_result v_table_name%ROWTYPE

but that's not allowed either.

Then I tried to use this:

v_result v_data%TYPE

where v_data is an argument of the same function with anyelement
datatype, but no luck.

Is there a way to declare such a pseudo-type variable inside the stored
procedure?

Thank you in advance,
Kaarel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-26 00:47:29 Re: Question about anyelement datatype
Previous Message Grzegorz Jaśkiewicz 2008-11-25 22:33:23 Re: two or more pg installations running as the same user