Re: point(lseg,lseg) does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shane <shane-pgsql(at)cm(dot)nu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: point(lseg,lseg) does not exist
Date: 2005-07-18 17:59:42
Message-ID: 15539.1121709582@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shane <shane-pgsql(at)cm(dot)nu> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Luiz Fernando de Menezes Calabria 2005-07-18 18:24:23 unsubscribe
Previous Message Ying Lu 2005-07-18 17:56:33 About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.)