I think the problem is simpler than that, s<span>elect
postgis_full_version(); gives the same error.<br><br>Is there a step I'm missing to initialize the db with the functions?<br></span><br><div><span class="gmail_quote">On 27/08/07, <b class="gmail_sendername">Obe, Regina
</b> <<a href="mailto:robe.dnd@cityofboston.gov">robe.dnd@cityofboston.gov</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff">
<div dir="ltr" align="left"> </div>
<div><span></span>To add you should check which version you have installed</div>
<div> </div>
<div><span></span><span></span>B<span>y running the
following</span></div>
<div><span></span> </div>
<div><span></span>s<span>elect
postgis_full_version();</span></div>
<div><span></span> </div>
<div><span>If it returns something lower than 1.2.2
then you should use the names without the ST in front of them.</span></div>
<div><span></span> </div>
<div><span>I developed 2 cheatsheets.
</span></div>
<div><span></span> </div>
<div><span>One is for 1.2.1</span></div>
<div><span></span><span><a href="http://www.bostongis.com/postgis_quickguide_1_2_1.bqg" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www..bostongis.com/postgis_quickguide_1_2_1.bqg</a></span>
</div>
<div><span></span> </div>
<div><span>and one is for 1.3.1</span></div>
<div><span><a href="http://www.bostongis.com/postgis_quickguide.bqg" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.bostongis.com/postgis_quickguide.bqg</a></span></div>
<div><span></span> </div>
<div><span>I'm still fleshing out the examples and gaps
in both. Hopefully these will be of benefit to
you. </span></div>
<div><span></span> </div>
<div><span>Thanks,</span></div>
<div><span>Regina </span></div>
<div><br></div>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Milo
van der Linden<br><b>Sent:</b> Monday, August 27, 2007 4:19 PM<br><b>To:</b>
PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] Geometry
Functions?<br></font><br></div><div><span class="e" id="q_114a903f1d2a9e1c_1">
<div></div>Hello Chris, <br><br>Welcome!<br><br>Try calling them without the ST_
in front of it:<br><br><span><span color="red"><span><code>SELECT transform(simplify(transform(the_geom, 2249),
500),4326) from neighborhoods<br><br>As described on:<br><br><a href="http://www.bostongis.com/postgis_simplify.snippet" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.bostongis.com/postgis_simplify.snippet
</a><br><br>Good
luck!<br><br></code></span></span></span>chris hinkle schreef:
<blockquote type="cite">Hi, very new to this, but I'm trying to call functions like
ST_Simplify and I'm getting errors telling me that the function doesn't
exist.<br><br>I installed Postgres and PostGIS using the binary windows
installers. What did I miss? <br clear="all"><br>-- <br>Chris
Hinkle<br>Brooklyn, NY<br><a href="mailto:lilhinx@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">lilhinx@gmail.com</a><br>646-240-3024 <pre><hr size="4" width="90%">
_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users@postgis.refractions.net
</a>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre></blockquote><br><br>
<div>-- <br>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br></td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p>Milo van der Linden <br><a>skype: milovanderlinden</a><br><a href="mailto:mlinden@zeelandnet.nl" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mlinden@zeelandnet.nl</a><br><a href="mailto:milovanderlinden@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
milovanderlinden@gmail.com</a><br><a href="mailto:milo@3dsite.nl" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">milo@3dsite.nl</a><br><a href="http://www.3dsite.nl" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.3dsite.nl</a><br></p></td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p><span lang="NL">De informatie in dit bericht reflecteert
mijn persoonlijke mening en niet die van een bedrijf of instantie. Aan de
informatie kunnen geen rechten worden ontleend. Indien dit bericht
onderdeel is van een forum, mailing-list of community dan gelden
automatisch de bij het betreffende medium behorende voorwaarden.</span>
<span lang="EN">The information in this message reflects my personal opinion
and not that of a company or public body. All rights reserved.If this
message is contained in a mailing-list or community, the rights on the
medium are automatically
adapted.</span></p></td></tr></tbody></table></div></span></div></div>
<div><p></p><hr size="1"><p></p>
<p><strong>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</strong></p></div><br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>
</blockquote></div><br><br clear="all"><br>-- <br>Chris Hinkle<br>Brooklyn, NY<br><a href="mailto:lilhinx@gmail.com">lilhinx@gmail.com</a><br>646-240-3024