"Peter Zeltins" <[EMAIL PROTECTED]> writes:
> 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
> select www_get_data ('test','USERS','QUERY',CAST(('%','%','','','') as =
> mytable),CAST(('%','%','','','') as mytable))
ANYELEMENT only matches scalar types. I don't think we have any support
for accepting an arbitrary row type as a function argument. There's
been some speculation about allowing RECORD to do that, but it's not
done.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
