[BUGS] BUG #3532: Can't rollup array of arrays

2007-08-10 Thread James William Pye
The following bug has been logged online: Bug reference: 3532 Logged by: James William Pye Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: FreeBSD Description:Can't rollup array of arrays Details: Dunno about the spec, but I would

Re: [BUGS] BUG #2240: length() with geometric types

2006-02-06 Thread James William Pye
hat way? If yes, why? Yes. You specified your path as a closed path. With its "loopback", it's twice as long. To specify it as an open path, do path('[(0,0),(2,0)]'). SELECT length(path('[(1,0),(0,0)]')) = '1'; SELECT length(path('(1,0),(0,0)&#