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
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
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