Received: from development.faams.net (faams.net [207.239.237.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAKJpBm39029 for ; Tue, 20 Nov 2001 14:51:11 -0500 (EST) (envelope-from hal@faams.net) Received: from faams.net (hal@faams.net [207.239.237.65]) by development.faams.net (8.9.3/8.7.2) with ESMTP id OAA11550 for ; Tue, 20 Nov 2001 14:49:59 -0500 Date: Tue, 20 Nov 2001 14:49:59 -0500 (EST) From: Hal Davison To: pgsql-interfaces@postgresql.org Subject: Re: [PHP] postgresql array with PHP In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/50 X-Sequence-Number: 2110 Wunner why in the origional design of PostgreSQL that an array function was not considered? Any Clue? =========================================================== Hal Davsion Internet Petroleum Distribution Petroleum Data Solutions,Inc. LSE Linux V1.22 6850 Myakka Valley Tr PostgreSQL 7.03 - Sun Forte - JAVA Sarasota, Florida 34241 Phone: (941) 921-6578 http://www.faams.net eFAX: (419) 821-5999 =========================================================== On Mon, 2 Apr 2001, Grant wrote: > I had the same problem. > > I believe having an array field type in a database table doesn't help keep > atomicity of the database. > > What I did was, thought about my table schema a little more. Worked out > that I can use the array field type for only storing numbers. Why? > > When I receive the row from postgres I explode it. If I was using text in > the array, it may contain "," which would then ruin the explode. > > Where $row[6] is the selected array field containing only numbers. > > $new_array = explode(",", ereg_replace("[{-}]", "", $row[6])); > > I was talking to rasmus ages back and he said there is no support for > arrays from postgresql. > > On Sat, 31 Mar 2001 darius@shell.bourg.net wrote: > > > Hello All, > > > > I have a few array types in a table that I'd like to update/retrieve from > > PHP. I manage to update/insert the array with a common sql statement but > > am having a tough time retrieving the data back into an array like > > form. PHP seems to store the result of a Postgresql array as a single > > element. Is there a simple way to retrieve Postgresql array datatypes as > > a PHP array instead of a single element? > > > > Thanks, > > > > Steve Bourg > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >