15 $c = new pq\Connection(PQ_DSN);
16 $r = $c->exec("SET timezone TO UTC; SELECT
22 1.1::float4 as float4,
23 2.2::float8 as float8,
24 '2013-01-01'::date as date,
25 '2013-01-01 01:01:01'::timestamp as timestamp,
26 '2013-01-01 01:01:01 UTC'::timestamptz as timestamptz,
27 array[array[1,2,3],array[4,5,6],array[NULL::int,NULL::int,NULL::int]] as intarray,
28 array[box(point(1,2),point(2,3)),box(point(4,5),point(5,6))] as boxarray
30 var_dump($r->fetchRow(pq\Result::FETCH_ASSOC));
51 object(pq\DateTime)#%d (4) {
55 string(%d) "2013-01-01 00:00:00%r(\.000000)?%r"
62 object(pq\DateTime)#%d (4) {
64 string(13) "Y-m-d H:i:s.u"
66 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
73 object(pq\DateTime)#%d (4) {
75 string(14) "Y-m-d H:i:s.uO"
77 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
116 string(11) "(2,3),(1,2)"
118 string(11) "(5,6),(4,5)"