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: [email protected] [mailto:[email protected]] On Behalf Of John Sent: Thursday, June 10, 2010 4:22 AM To: [email protected] 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 -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
