<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi list,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm trying do insert some lines into a
spatial table and I don't know how to do it,</FONT></DIV>
<DIV><FONT face=Arial size=2>Please, what's wrong ??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> My code is: </FONT></DIV>
<DIV><FONT face=Arial size=2> poligono :=
'POLYGON(('||x1||' '||y1||','||x2||' '||y1||','||x2||' '||y2||','||x1||'
'||y2||','||x1||' '||y1||'))';<BR> INSERT INTO sp VALUES
(geoid,nome,GeometryFromText(poligono,-1));<BR></FONT></DIV>
<DIV><FONT face=Arial size=2> The error message is :
</FONT></DIV>
<DIV><FONT face=Arial size=2> ERROR: Function
geometryfromtext(character varying, integer) does not
exist<BR> Unable to identify a function that satisfies
the given argument types<BR> You may need to add
explicit typecasts</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> geoid, nome, x1,y1,x2,y2 are
variables of my function</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rosangela</DIV></FONT></BODY></HTML>