Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id EC49F633F5D for ; Tue, 26 May 2009 08:59:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 32121-06 for ; Tue, 26 May 2009 08:59:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13]) by mail.postgresql.org (Postfix) with ESMTP id CF2D6633F13 for ; Tue, 26 May 2009 08:59:13 -0300 (ADT) Received: from gonzo (ip-118-90-131-244.xdsl.xnet.co.nz [118.90.131.244]) by titania.wxnz.net (Postfix) with ESMTP id 650101DB80A2 for ; Tue, 26 May 2009 23:59:10 +1200 (NZST) Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1M8vHp-0002aH-7Q for pgsql-php@postgresql.org; Tue, 26 May 2009 23:57:41 +1200 To: pgsql-php@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.php Subject: Re: PDO, postgre and PHP data types Date: 26 May 2009 11:57:40 GMT Organization: Dis (not Dat) Organisation Lines: 20 Message-ID: References: <1243278537.18371.16.camel@localhost.localdomain> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1243339060 9212 127.0.0.1 (26 May 2009 11:57:40 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200905/10 X-Sequence-Number: 4030 On 2009-05-25, Developer wrote: > Hello, > I have some problem with data type of PDO returned instance, array of > integer (_int4[]) is returned as string. yes. > I read ref.pgsql.php, but nothing said how solve this problem. > I use something like this for it: > $dat=array($k=>explode(',',trim($v,'{}'))); // One dimension array > But it is very slow. Any method to return correct data types from > DATABASE to PHP parsed with high speed code (like C)? php will never be "fast like c" if you are not using the arrays with postgres stored procedures, perhaps you could store them in a format that PHP is handles better (eg: serialize)