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,
29 array[]::text[] as emptyarray,
30 'foo\n'::bytea as bytea,
31 'foo\n'::bytea::text as bytea_text
33 var_dump($r->fetchRow(pq\Result::FETCH_ASSOC));
54 object(pq\DateTime)#%d (4) {
58 string(%d) "2013-01-01 00:00:00%r(\.000000)?%r"
65 object(pq\DateTime)#%d (4) {
67 string(13) "Y-m-d H:i:s.u"
69 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
76 object(pq\DateTime)#%d (4) {
78 string(14) "Y-m-d H:i:s.uO"
80 string(%d) "2013-01-01 01:01:01%r(\.000000)?%r"
119 string(11) "(2,3),(1,2)"
121 string(11) "(5,6),(4,5)"
130 string(10) "\x666f6f0a"