Re: [GENERAL] PHP and Postgres arrays
Hannes Dorbath wrote: Yannick Warnier wrote: I thought about it, but it's not very portable if you want to ship a PHP application. But I admit I will fall back to that solution if I cannot find any other (considering PostgreSQL might be the only open-source database to offer in-fields arrays anyway). You can use the build in function array_to_string: http://www.postgresql.org/docs/8.3/static/functions-array.html Then use implode(YOUR_DELIMITER, YOUR_STRING) to get an array. Another solution would be to use the MDB2 (or similar) PEAR wrapper. b ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] PHP and Postgres arrays
Yannick Warnier wrote: I thought about it, but it's not very portable if you want to ship a PHP application. But I admit I will fall back to that solution if I cannot find any other (considering PostgreSQL might be the only open-source database to offer in-fields arrays anyway). You can use the build in function array_to_string: http://www.postgresql.org/docs/8.3/static/functions-array.html -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] PHP and Postgres arrays
Le vendredi 18 janvier 2008 à 23:10 +0100, Ivan Sergio Borgonovo a écrit : > On Fri, 18 Jan 2008 23:01:09 +0100 > Yannick Warnier <[EMAIL PROTECTED]> wrote: > > > 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. > > What about using a stored procedure to return the array as a joined > row? I thought about it, but it's not very portable if you want to ship a PHP application. But I admit I will fall back to that solution if I cannot find any other (considering PostgreSQL might be the only open-source database to offer in-fields arrays anyway). Yannick ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] PHP and Postgres arrays
On Fri, 18 Jan 2008 23:01:09 +0100 Yannick Warnier <[EMAIL PROTECTED]> wrote: > 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. What about using a stored procedure to return the array as a joined row? -- Ivan Sergio Borgonovo http://www.webthatworks.it ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] PHP and Postgres arrays
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend