PDO, postgre and PHP data types

PDO, postgre and PHP data types

am 25.05.2009 21:08:57 von developer

Hello,
I have some problem with data type of PDO returned instance, array of
integer (_int4[]) is returned as string.

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)?
Any postgresql driver version?




--














--
--
Publicidad y Servicios http://www.pas-world.com
Directorio http://www.precioventa.com
Tienda http://informatica.precioventa.com/es/
Autoridad certificadora http://ca.precioventa.com/es/
--
--


--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PDO, postgre and PHP data types

am 26.05.2009 01:13:47 von dmagick

Developer wrote:
> Hello,
> I have some problem with data type of PDO returned instance, array of
> integer (_int4[]) is returned as string.
>
> 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)?
> Any postgresql driver version?

PDO will only know basic data types (strings, int, possibly bool) and an
int array is not a basic type. It's also designed to be 'database
independent' so this won't be included at all most likely.

If you want it in C, you'll have to put it together yourself but I doubt
it'd ever be included in php core (but you can always try).

--
Postgresql & php tutorials
http://www.designmagick.com/


--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: PDO, postgre and PHP data types

am 26.05.2009 13:57:40 von Jasen Betts

On 2009-05-25, Developer 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)


--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php