<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff size=2>What
version of PostgreSQL are you using? Also can you show us the complete function
including the CREATE FUNCTION line?</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff size=2>Kind
regards,</FONT></SPAN></DIV>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=388154015-20062005><FONT face=Arial color=#0000ff
size=2>Mark.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>------------------------<BR>WebBased Ltd<BR>17 Research
Way<BR>Tamar Science Park<BR>Plymouth<BR>PL6 8BT<BR><BR>T: +44 (0)1752
797131<BR>F: +44 (0)1752 791023<BR>W: <A
href="http://www.webbased.co.uk/">http://www.webbased.co.uk</A><BR> </FONT>
</P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>rsosnowski@cableone.net<BR><B>Sent:</B> 17 June 2005 22:54<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Cc:</B>
rsosnowski@cableone.net<BR><B>Subject:</B> [postgis-users]
envelope<BR><BR></FONT></DIV>
<P>Hello all,<BR><BR>Trying to write a stored procedure that returns the
envelope.<BR><BR>Code follows:<BR><BR> sSQLExp:= 'SELECT the_geom FROM '
|| quote_ident(stable) || ' WHERE ' || quote_ident(sfield) || ' = ' ||
quote_literal(svalue);<BR> RAISE NOTICE 'sSQLExp = %',
sSQLExp;<BR> OPEN pTempCursor FOR EXECUTE sSQLExp;<BR>
LOOP<BR> FETCH pTempCursor INTO
pFeatureGeometry;<BR> EXIT WHEN NOT
FOUND;<BR> sSQL:= 'SELECT envelope(' || sSQLExp
|| ') FROM ' || quote_ident(stable);<BR> RAISE
NOTICE 'sSQL = %', sSQL;</P>
<P> OPEN pCursor FOR EXECUTE sSQL;<BR>
LOOP<BR> FETCH pCursor INTO
pBoundBox;<BR> EXIT WHEN NOT
FOUND; <BR> END LOOP;<BR> END
LOOP;<BR> CLOSE pCursor;<BR> CLOSE
pTempCursor;<BR><BR>************************************************************<BR>THE
SECOND NOTICE STATEMENT SHOWS:<BR>sSQL = SELECT envelope(SELECT the_geom FROM
subdiv WHERE subdivname = 'HIGHLANDER ESTATES') FROM subdiv<BR><BR>GET THE
FOLLOWING ERROR:<BR><BR>SYNTAX ERROR AT OR NEAR "SELECT" AT CHARACTER 17;
POINTS TO THE 'S' IN THE SECOND SELECT STATEMENT.<BR> SELECT
ENVELOPE(SELECT.....<BR> <BR>ANY
IDEAS????<BR><BR><BR></P><BR></BLOCKQUOTE></BODY></HTML>