From: | gulsumramazanoglu <gulsumramazanoglu(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, anand086 <anand086(at)gmail(dot)com> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | YNT: Re: YNT: Re: Using bind variable within BEGIN END |
Date: | 2017-06-02 20:19:17 |
Message-ID: | t2bcjylen3u0or1325mbd6cc.1496434757258@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Thank you guys for all replies, before asking more and taking your valuble time i need to read some more.. it would be weird not to be able to do that in such a strong db like PostgreSQL as it is, the reason of question marks is about me, not the db:) .. thanks again..
Samsung cihazımdan gönderildi
-------- Orjinal mesaj --------
Kimden: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Tarih: 2 06 2017 11:00 PM (GMT+02:00)
Alıcı: gulsumramazanoglu <gulsumramazanoglu(at)gmail(dot)com>, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, anand086 <anand086(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Konu: Re: YNT: Re: [SQL] Using bind variable within BEGIN END
On 06/02/2017 11:38 AM, gulsumramazanoglu wrote:
> ... which will pass arguments and get back a result set, i mean..
Using Python and psycopg2:
\df billing_days
List of functions
Schema | Name | Result data type | Argument data
types | Type
--------+--------------+--------------------------+--------------------------------+--------
public | billing_days | TABLE(billing_date date) | start_date date,
end_date date | normal
select * from billing_days('05/01/2017', '05/30/2017');
billing_date
--------------
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05
2017-05-08
2017-05-09
2017-05-10
2017-05-11
2017-05-12
2017-05-15
2017-05-16
2017-05-17
2017-05-18
2017-05-19
2017-05-22
2017-05-23
2017-05-24
2017-05-25
2017-05-26
2017-05-29
2017-05-30
import psycopg2
con = psycopg2.connect('dbname=**** user=***_admin host=localhost')
bill_cur = con.cursor()
bill_cur.execute("SELECT * FROM billing_days(%s, %s)" , ('05/01/2017',
'05/31/2017'))
bill_rs = bill_cur.fetchall()
for row in bill_rs:
print(row[0])
2017-05-01
2017-05-02
2017-05-03
2017-05-04
2017-05-05
2017-05-08
2017-05-09
2017-05-10
2017-05-11
2017-05-12
2017-05-15
2017-05-16
2017-05-17
2017-05-18
2017-05-19
2017-05-22
2017-05-23
2017-05-24
2017-05-25
2017-05-26
2017-05-29
2017-05-30
2017-05-31
>
>
>
> Samsung cihazımdan gönderildi
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | anand086 | 2017-06-05 20:44:53 | Delete failing with -- permission denied |
Previous Message | Adrian Klaver | 2017-06-02 20:00:24 | Re: YNT: Re: Using bind variable within BEGIN END |