Re: [SQL] what does this do

2010-06-10 Thread Tim Landscheidt
Richard Broersma wrote: >>> 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

Re: [SQL] what does this do

2010-06-10 Thread John
st/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 > Sub

Re: [SQL] what does this do

2010-06-10 Thread Little, Douglas
- 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 *

Re: [SQL] what does this do

2010-06-10 Thread Richard Broersma
On Thu, Jun 10, 2010 at 3:57 AM, Tim Landscheidt wrote: > John wrote: > >> 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 "enrollid

[SQL] what does this do

2010-06-10 Thread John
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.

Re: [SQL] what does this do

2010-06-10 Thread Tim Landscheidt
John wrote: > 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 >