Thread: PDO, postgre and PHP data types

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/
--
--

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/

On 2009-05-25, Developer <dev002@pas-world.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)