Re: function to operate on same fields, different records?

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: "Eric G(dot) Miller" <egm2(at)jps(dot)net>
Subject: Re: function to operate on same fields, different records?
Date: 2001-04-02 06:47:29
Message-ID: 20010402014729.A7331@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Mar 31, 2001 at 11:52:47AM -0800, Eric G. Miller wrote:
> I think you still can have a function that uses field names. But then
> your field names *have* to be the same. That's the only difference.

i've tried

create function gpa(OPAQUE) ....

and psql tells me it successfully

CREATED

something, but

\df

shows no such function.

if i do

create function gpa(classTable) ...

then it probably won't be called via

select gpa(studentTable) ...

what arg to i specify to allow varying records (with a subset of
exactly-the-same-names field subset) to be passed to a function?

--
does a brain cell think?

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-04-02 06:49:53 Re: Call for platforms
Previous Message Tom Lane 2001-04-02 06:27:47 Re: dynamic field names in a function.