diff options
Diffstat (limited to 'sandbox/array.py')
| -rw-r--r-- | sandbox/array.py | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/sandbox/array.py b/sandbox/array.py index af09140..5d37776 100644 --- a/sandbox/array.py +++ b/sandbox/array.py @@ -4,14 +4,18 @@ conn = psycopg.connect("dbname=test") curs = conn.cursor() curs.execute("SELECT ARRAY[1,2,3] AS foo") -print curs.fetchone() +print curs.fetchone()[0] curs.execute("SELECT ARRAY['1','2','3'] AS foo") -print curs.fetchone() +print curs.fetchone()[0] curs.execute("""SELECT ARRAY[',','"','\\\\'] AS foo""") -d = curs.fetchone() -print d, '->', d[0][0], d[0][1], d[0][2] +d = curs.fetchone()[0] +print d, '->', d[0], d[1], d[2] curs.execute("SELECT ARRAY[ARRAY[1,2],ARRAY[3,4]] AS foo") -print curs.fetchone() +print curs.fetchone()[0] + +curs.execute("SELECT ARRAY['20:00:01'::time] AS foo") +print curs.description +print curs.fetchone()[0] |