Shane <shane-pgsql@xxxxx> writes:
> I am attempting a query using lseg values to find the point
> of intersection. The following query taken from the PG
> manual isn't working over here.
> select
> point(lseg '((-1,0),(1,0))', lseg
> '((-2,-2),(2,2))')
> ERROR: function point(lseg, lseg) does not exist
Hm, seems to be a thinko in the documentation. The function you
actually want is lseg_interpt(), which would probably be better
invoked via the documented operator lseg # lseg.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
