Skip site navigation (1) Skip section navigation (2)

Re: BUG #4638: Bug with Geometry in Array

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bjoern Weitzig" <weitzig(at)supportgis(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4638: Bug with Geometry in Array
Date: 2009-02-03 17:43:22
Message-ID: 29295.1233683002@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Bjoern Weitzig" <weitzig(at)supportgis(dot)de> writes:
> I use arrays like "select array(select n from a)". This works well except of
> the case with geometry as datatype. 

The geometry type intentionally uses ':' as the array delimiter.  It
seems like a good bet that the JDBC driver you're using doesn't expect
anything but ',' as array delimiter.  I checked with the postgis-devel
list and they recommend using the modified JDBC driver that's
distributed with postgis.
http://postgis.refractions.net/documentation/manual-1.3.6SVN/ch04.html#id2726248

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Joshua TolleyDate: 2009-02-03 18:31:32
Subject: Behavior of identically-named savepoints
Previous:From: Bjoern WeitzigDate: 2009-02-03 12:49:22
Subject: BUG #4638: Bug with Geometry in Array

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group