Re: [GENERAL] Using rowtype parameter

2006-01-20 Thread Peter Zeltins
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. OK, that clears it up. RECORD would actually do nicely. Right now I'll be forc

[GENERAL] Using rowtype parameter

2006-01-19 Thread Peter Zeltins
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 t