Re: what does this do

First remove the python
select * from jfcs_balancedue(parameter) f(enrolleeid varchar,course_cost decimal, paid_amt decimal)

the jfcs_balancedue is a table function, f is the alias (with the column alias list/datatype of the columns returned by the function).

Doug

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of John
Sent: Thursday, June 10, 2010 4:22 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] what does this do

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