pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: Janning Vygen <vygen@gmx.de>
Cc: pgsql-php@postgresql.org, Greg Stark <gsstark@mit.edu>
Subject: Re: How to parse data type array columns?
Date: 16 Aug 2005 16:08:01 -0400
Message-ID: <873bp9ve5a.fsf@stark.xeocode.com> (raw)
In-Reply-To: <200508162025.17280.vygen@gmx.de>
References: <200508161004.07400.vygen@gmx.de>
	<871x4tx6rv.fsf@stark.xeocode.com>
	<200508162025.17280.vygen@gmx.de>


Janning Vygen <vygen@gmx.de> writes:

> What kind of "binary format" do you mean? anyway: In PHP you get it as a 
> string and i wonder if anyone has written a small pasrer function for php to 
> handle this string an convert it into an php array structure.

The server can provide each data type in either ascii format or in a binary
representation. In general the binary representation is something that's
easier and more efficient to process by machine. I'm not sure what the array
representation looks like though.

I don't know whether the PHP driver uses binary representations for anything.
If it does it would make things like integers (imperceptibly) faster and
possibly slightly more reliable. In the case of arrays it would maybe make it
easier to code and maybe significantly more efficient.

It's possible it's already using binary mode for some data types and just
isn't for arrays. But I suspect it isn't.

-- 
greg




view thread (10+ messages)  latest in thread

Message-ID: <873bp9ve5a.fsf@stark.xeocode.com>
Permalink:  ../873bp9ve5a.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/873bp9ve5a.fsf@stark.xeocode.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: gsstark@mit.edu, vygen@gmx.de
  Subject: Re: How to parse data type array columns?
  In-Reply-To: <873bp9ve5a.fsf@stark.xeocode.com>
  References: <200508161004.07400.vygen@gmx.de> <871x4tx6rv.fsf@stark.xeocode.com> <200508162025.17280.vygen@gmx.de> <873bp9ve5a.fsf@stark.xeocode.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox