On Wed, 27 Sep 2006, Dan Libby wrote:
> Background:
>
> I have a hierarchical table where I have coordinate data for only the leaf
> nodes. I therefore want to find the center of all the leaf nodes under a
> given parent node, and set the parent node coordinate to that center point.
>
> I can cal
On Wed, Sep 27, 2006 at 08:14:29PM -0600, Dan Libby wrote:
> Hi all,
>
> Using pgsql 8.0.1
>
> I'm just starting with using the geometry data types in postgres, and ran
> into
> what seems like a very basic problem. Namely, I can't seem to convert/cast
> type text into type point when that t
Hi all,
Using pgsql 8.0.1
I'm just starting with using the geometry data types in postgres, and ran into
what seems like a very basic problem. Namely, I can't seem to convert/cast
type text into type point when that text results from any expression. Ie, it
*only* works for a plain string li
