Re: Postgres arrays
| From: | Jouni Ahto | Date: | Wed, 31 May 2000 16:11:11 +0000 |
| Subject: | Re: Postgres arrays | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-141@lists.php.net to get a copy of this message | ||
On Wed, 31 May 2000 Robert.Mallozzi@msfc.nasa.gov wrote:
>
> Hello,
>
> I am using PHP4 with a PostgreSQL database. This db allows
> the use of array variables in data table fields, and there
> seems to be a problem extracting the arrays through PHP.
> When I query the table, the array value gets returned as
> a string, formatted something like this for a (2, 4)
> array:
>
>
> {{"-58.88","-11.776"},{"0","0"},{"0","0"},{"0","0"}}
>
> Why isn't PHP returning an array instead of a
> string? Is there any way to return the values as
> an array?
That's the way PostgreSQL libraries return array data, as a string.
Nothing we can do about it. You'll have to write yourself something that
parses the string.
-- Jouni Ahto