what does this do

From: John <johnf(at)jfcomputer(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: what does this do
Date: 2010-06-10 09:22:03
Message-ID: 201006100222.03196.johnf@jfcomputer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I have a piece of python code that excutes a SQL statement:

apitempCur.execute("select * from jfcs_balancedue('%s') f(enrolleeid varchar,
course_cost decimal, paid_amt decimal)" % (enrollIds,));

The "enrollids" is a list of primary keys and the "jfcs_balancedue" is a user
defined function. What I don't understand is the "f(enrolleeid
varchar, ...)" I have no idea what it's for? Would some kind soul educate
me.

Thanks in advance,
Jhnf

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Landscheidt 2010-06-10 10:57:07 Re: what does this do
Previous Message Aaron Burnett 2010-06-08 18:20:08 Re: Some insight on the proper SQL would be appreciated