<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New"
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>The PostGIS
online documentation mentions a function 'GeometryFromWKB' under 'Other
functions'.</FONT></SPAN></DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>However,
when I try to use it, e.g. like this:</FONT></SPAN></DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>select
AsText(GeometryFromWKB('010100000000000000000024400000000000003440'::wkb,
4326));</FONT></SPAN></DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>I well get
the error message:</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>ERROR: Function geometryfromwkb(wkb,
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="Courier New" size=2></FONT> </DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>Is this
function not yet implemented? If not, then when is it going to be implemented? I
believe that GeometryFromWKB() would be a lot faster than GeometryFromText()
when a large number of geometries (e.g. > 100,000) are inserted into a
table. Is there any chance that it will be implemented soon?</FONT></SPAN></DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=437564907-23102003><FONT face="Courier New" size=2>The PostGIS
version I'm using is 0.7, PostGreSQL is 7.3.4.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV align=left>
<DIV class=Section1>
<P style="MARGIN: 0cm 0cm 0pt" align=left><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Best regards,</SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt" align=left><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"></SPAN> </P>
<P style="MARGIN: 0cm 0cm 0pt" align=left><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><STRONG>Martin <SPAN
class=SpellE>Schäfer</SPAN><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></STRONG></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><STRONG>Senior Software
Engineer</STRONG></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><STRONG>Cadcorp</STRONG></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Computer Aided Development
Corp. Ltd.<o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><?xml:namespace prefix = st1 ns =
"urn:schemas-microsoft-com:office:smarttags" /><st1:address
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"><st1:Street><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">4 Fitzroy
Square</SPAN></st1:Street><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">, </SPAN><st1:City><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">London</SPAN></st1:City><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">,
</SPAN><st1:PostalCode><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">W1T
5HQ</SPAN></st1:PostalCode></st1:address><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN class=GramE><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Tel:</SPAN></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> +44 (0) 20 7383
0015<o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Fax: +44 (0) 20 7388
6313<o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><A
href="mailto:martin.schaefer@cadcorp.com">martin.schaefer@cadcorp.com</A><o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><A
href="file:///C:/Documents%20and%20Settings/martins/Application%20Data/Microsoft/Signatures/www.cadcorp.com">www.cadcorp.com</A></SPAN></P></DIV></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV></BODY></HTML>