From: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
---|---|
To: | John <johnf(at)jfcomputer(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: what does this do |
Date: | 2010-06-10 13:46:46 |
Message-ID: | 8585BA53443004458E0BAA6134C5A7FB06795979@EGEXCMB01.oww.root.lcl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John | 2010-06-10 14:03:55 | Re: what does this do |
Previous Message | Richard Broersma | 2010-06-10 13:42:27 | Re: what does this do |