<!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.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Georgia size=2>
<DIV><FONT face=Georgia size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2>I am using the PostGIS to do research. Here I
think that I found a </FONT><FONT face=Georgia size=2>bug with PostGreSQL /
PostGIS.</FONT></DIV>
<DIV><FONT face=Georgia size=2>PostgreSQL 7.1.3/ PostGIS 0.6.2</FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2>There is a function called "Astext" in PostGIS,
defined as below.</FONT></DIV>
<DIV><FONT face=Georgia size=2> -- Function:
astext(geometry)<BR> CREATE FUNCTION "astext"("geometry")
RETURNS "text" AS 'astext_geometry' LANGUAGE 'C' WITH
(ISSTRICT);<BR></FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT><FONT face=Georgia size=2>When I used this
function to return a geometry column, everything is OK if the result was less
than 8190.</FONT></DIV>
<DIV><FONT face=Georgia size=2>I used the ODBC to get
the ADO RecordSet. The <FONT face="Times New Roman"
size=3>DefinedSize of the </FONT>field "astext" is
8190. </FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2>Does this the PostgreSQL's ODBC problem? If
the ODBC can not get the field's size, would it give the size of
8190?</FONT></DIV>
<DIV><FONT face=Georgia size=2>Or this is the PostGIS's problem?</FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2>Best regards,<BR>Tony</FONT></DIV>
<DIV><FONT face=Georgia size=2></FONT> </DIV>
<DIV><FONT face=Georgia size=2>---<BR>Tony Jiang, MSc<BR>Research &
Development Programmer/Analyst<BR>MRF Geosystems Corp (<A
href="http://www.mrf.com">www.mrf.com</A>)<BR>Suite 700, 665 8th Street SW,
<BR>Calgary, AB T2P 3K7<BR>(403) 216-5515 ext:226</FONT></FONT><FONT
face=Georgia size=2></FONT></DIV></DIV>
<br>
<tt>
To unsubscribe from this group, send an email to:<BR>
postgis-unsubscribe@yahoogroups.com<BR>
<BR>
</tt>
<br>
<br>
<tt>Your use of Yahoo! Groups is subject to the <a href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.</tt>
</br>
</BODY></HTML>