Re: [SQL] how to call a function with row-type arg

2003-09-12 Thread Tom Lane
sad <[EMAIL PROTECTED]> writes: > how to call a function with a row_type arg ?? > CREATE FUNCTION foo(tablename) returns int . SELECT foo(tablename) FROM tablename; or SELECT foo(tablename.*) FROM tablename; The first is traditional Postgres usage, but I think the second mak

Re: [SQL] how to call a function with row-type arg

2003-09-12 Thread Richard Hall
DECLARE     I INTEGER; BEGIN     SELECT *   INTO I   FROM foo( ) That part is easy, but I don't understand what you are using as a function parameter. Rick sad wrote: hi  how to call a function with a row_type arg ??  that is the question CREATE FUNCTION foo(tablename) returns

[SQL] how to call a function with row-type arg

2003-09-11 Thread sad
hi how to call a function with a row_type arg ?? that is the question CREATE FUNCTION foo(tablename) returns int . SELECT foo ( ??? ); ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings