agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: gulsumramazanoglu <gulsumramazanoglu@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: anand086 <anand086@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: YNT: Re: Using bind variable within BEGIN END
Date: Fri, 2 Jun 2017 13:00:24 -0700
Message-ID: <c5ee822d-d3f1-0960-5392-80b00ff77a5b@aklaver.com> (raw)
In-Reply-To: <kdf2tkyatlx830fud5f1g71u.1496428694928@email.android.com>
References: <kdf2tkyatlx830fud5f1g71u.1496428694928@email.android.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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.klaver@aklaver.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (3+ messages)
Message-ID: <c5ee822d-d3f1-0960-5392-80b00ff77a5b@aklaver.com>
Permalink: ../c5ee822d-d3f1-0960-5392-80b00ff77a5b@aklaver.com/
Also on: postgresql.org/message-id/c5ee822d-d3f1-0960-5392-80b00ff77a5b@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, gulsumramazanoglu@gmail.com, david.g.johnston@gmail.com, anand086@gmail.com
Subject: Re: YNT: Re: Using bind variable within BEGIN END
In-Reply-To: <c5ee822d-d3f1-0960-5392-80b00ff77a5b@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox