[postgis-users] Need some help

[strk]

On Thu, Aug 05, 2004 at 10:53:06AM -0600, Zamil Murji wrote:
> Hello list,
> 
> I have a column in a table defined as a LINESTRING, the lines display just fine using mapserver. Now I want to create a line that is perpendicular to that line, but I want to do it with SQL. I can get the end point of the line, but I'm at a loss of what to do next. My goal is to create a T with the line that is already stored in the db. What is the quickest way to do something like this.
> 
> Thanks in advance,
> Zamil

Postgis does not currently support creating geometries with SQL.
You need pl/pgsql for that. 

--strk;