X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 140BB52834 for ; Tue, 16 Aug 2005 23:16:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80481-09 for ; Wed, 17 Aug 2005 02:16:52 +0000 (GMT) Received: from houston.familyhealth.com.au (houston.au.fhnetwork.com [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 1BD1952ABD for ; Tue, 16 Aug 2005 23:16:50 -0300 (ADT) Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id 182C424FFF; Wed, 17 Aug 2005 10:16:49 +0800 (WST) Received: from [127.0.0.1] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id 9827924FE6; Wed, 17 Aug 2005 10:16:30 +0800 (WST) Message-ID: <43029E9F.2020502@familyhealth.com.au> Date: Wed, 17 Aug 2005 10:19:11 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: Janning Vygen , pgsql-php@postgresql.org Subject: Re: How to parse data type array columns? References: <200508161004.07400.vygen@gmx.de> <871x4tx6rv.fsf@stark.xeocode.com> In-Reply-To: <871x4tx6rv.fsf@stark.xeocode.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-familyhealth-MailScanner-Information: Please contact the ISP for more information X-familyhealth-MailScanner: Found to be clean X-familyhealth-MailScanner-From: chriskl@familyhealth.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.062 required=5 tests=[AWL=0.012, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/8 X-Sequence-Number: 3220 >>if you use array data type in your database design and query your tables with >>PHP you get a string which represents the array. It can look something like >>this: >> >>[1:2]{{"Hallo", "Te\"st},"},{"Hallo", "Test"}} > > > Do you still get that if you use the binary format? I would expect it to be > easier to parse the binary format than this format which is really intended > for humans and dump files. > > I think the right place to deal with this is down in the driver where it has > all the information about the types and can request the format it wants from > the database. I _really_ want to have an array parsing function in PHP...I'll have to check if they query in binary mode or not... Chris