Re: PDO, postgre and PHP data types

[Jasen Betts <jasen(at)xnet(dot)co(dot)nz>]

On 2009-05-25, Developer <dev002(at)pas-world(dot)com> wrote:
> Hello,
> I have some problem with data type of PDO returned instance, array of
> integer (_int4[]) is returned as string.

yes.

> I read ref.pgsql.php, but nothing said how solve this problem.

> I use something like this for it:
> $dat=array($k=>explode(',',trim($v,'{}'))); // One dimension array
> But it is very slow. Any method to return correct data types from
> DATABASE to PHP parsed with high speed code (like C)?

php will never be "fast like c"

if you are not using the arrays with postgres stored procedures,
perhaps you could store them in a format that PHP is handles better
(eg: serialize)