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

From: "Richard Hall" <rhall(at)micropat(dot)com>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to call a function with row-type arg
Date: 2003-09-12 13:35:57
Message-ID: 3F61CBBD.77B7EC68@micropat.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

DECLARE
I INTEGER;
BEGIN
SELECT *
INTO I
FROM foo( <tablename> )

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 int .....
>
> SELECT foo ( ??????? );
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message vijaykumar M 2003-09-12 13:49:36 createlang plpgsql failing on redhatlinux7.2
Previous Message Richard Huxton 2003-09-12 07:08:22 Re: How do I replace select ... into commands?