PHP and Postgres arrays

From: Yannick Warnier <ywarnier(at)beeznest(dot)org>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: PHP and Postgres arrays
Date: 2008-01-18 22:01:09
Message-ID: 1200693669.9992.457.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've been searching (not very thoroughly, but still) for a way to get
Postgres arrays right into PHP arrays, but it seems that the Postgres
driver simply doesn't allow that.

The only solution seems to use some user-defined functions[1] to split
the result of a query (a string) into a PHP array.

Some Perl-related readings [2] seem to say that Postgres actually
provides a string, loosing the possibility to get it as an array, but
these comments date back to 2005.

Any chance someone around here might tell me more about this and
possibly give me some better way to get those arrays than copy-pasting
the user-proposed PHP functions?

Thanks,

Yannick Warnier

[1] http://www.php.net/manual/en/ref.pgsql.php#58660
[2] http://www.perlmonks.org/?node_id=474518

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-01-18 22:10:59 Re: PHP and Postgres arrays
Previous Message Gordan Bobic 2008-01-18 21:53:23 Re: Replication Using Triggers