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