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 1::abstime as abstime,
26 '2013-01-01 01:01:01'::timestamp as timestamp,
27 '2013-01-01 01:01:01 UTC'::timestamptz as timestamptz,
28 array[array[1,2,3],array[4,5,6],array[NULL::int,NULL::int,NULL::int]] as intarray,
29 array[box(point(1,2),point(2,3)),box(point(4,5),point(5,6))] as boxarray
31 var_dump($r->fetchRow(pq\Result::FETCH_ASSOC));
52 object(pq\DateTime)#%d (4) {
56 string(%d) "2013-01-01 00:00:00%r(\.000000)?%r"
63 object(pq\DateTime)#%d (4) {
65 string(11) "Y-m-d H:i:s"
67 string(%d) "1970-01-01 00:00:01%r(\.000000)?%r"
74 object(pq\DateTime)#%d (4) {
76 string(13) "Y-m-d H:i:s.u"
78 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
85 object(pq\DateTime)#%d (4) {
87 string(14) "Y-m-d H:i:s.uO"
89 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
128 string(11) "(2,3),(1,2)"
130 string(11) "(5,6),(4,5)"