Using rowtype parameter

From: "Peter Zeltins" <peter(at)greatnowhere(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Using rowtype parameter
Date: 2006-01-19 12:04:52
Message-ID: 024201c61cf0$8e804ea0$0202fea9@komtek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to write a stored proc (in pl/Pgl) that can accept rowtypes as arguments:

CREATE or replace FUNCTION www_get_data(user_id "varchar", objectname "varchar", operation "varchar", primarykeyvalue anyelement, rowvalue anyelement)
RETURNS SETOF varchar[] AS
...

Whenever I try to typecast a rowtype in function call like this:

select www_get_data ('test','USERS','QUERY',CAST(('%','%','','','') as mytable),CAST(('%','%','','','') as mytable))

I get error message:

ERROR: could not determine actual argument type for polymorphic function "www_get_data"

What gives? I thought typecast should suffice? Are there any limitations on using composite data types for anyelement parms?

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-01-19 12:08:22 Re: Insert a default timestamp when nothing given
Previous Message Sean Davis 2006-01-19 12:03:47 Normalized storage to denormalized report