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

Re: [GENERAL] Using rowtype parameter

2006-01-19 Thread Tom Lane
"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) >

[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