|
191.1.1
by Federico Di Gregorio
Merge from 2_0_x branch up to r814. |
1 |
import psycopg2 |
|
42
by Federico Di Gregorio
Array quoting (not completely working.) |
2 |
|
|
262
by Federico Di Gregorio
Added support for NULL in arrays (closes: #154) |
3 |
conn = psycopg2.connect("port=5433 dbname=test") |
|
42
by Federico Di Gregorio
Array quoting (not completely working.) |
4 |
curs = conn.cursor() |
5 |
||
|
191.1.1
by Federico Di Gregorio
Merge from 2_0_x branch up to r814. |
6 |
#curs.execute("SELECT ARRAY[1,2,3] AS foo")
|
7 |
#print curs.fetchone()[0]
|
|
8 |
||
9 |
#curs.execute("SELECT ARRAY['1','2','3'] AS foo")
|
|
10 |
#print curs.fetchone()[0]
|
|
11 |
||
12 |
#curs.execute("""SELECT ARRAY[',','"','\\\\'] AS foo""")
|
|
13 |
#d = curs.fetchone()[0]
|
|
14 |
#print d, '->', d[0], d[1], d[2]
|
|
15 |
||
16 |
#curs.execute("SELECT ARRAY[ARRAY[1,2],ARRAY[3,4]] AS foo")
|
|
17 |
#print curs.fetchone()[0]
|
|
18 |
||
19 |
#curs.execute("SELECT ARRAY[ARRAY[now(), now()], ARRAY[now(), now()]] AS foo")
|
|
20 |
#print curs.description
|
|
21 |
#print curs.fetchone()[0]
|
|
22 |
||
|
262
by Federico Di Gregorio
Added support for NULL in arrays (closes: #154) |
23 |
#curs.execute("SELECT 1 AS foo, ARRAY[1,2] AS bar")
|
24 |
#print curs.fetchone()
|
|
25 |
||
26 |
#curs.execute("SELECT * FROM test()")
|
|
27 |
#print curs.fetchone()
|
|
28 |
||
29 |
curs.execute("SELECT %s", ([1,2,None],)) |
|
|
191.1.1
by Federico Di Gregorio
Merge from 2_0_x branch up to r814. |
30 |
print curs.fetchone() |
31 |