<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Times New Roman, Times, serif">This is such a weird
error that I ask for confirmation before submitting a bug. The
following declaration of a PostGIS connection does *not* work:<br>
<br>
connectiontype postgis<br>
connection "..."<br>
data " rd_bnd from (<br>
select gid,bladnr,rd_bnd from tmk.bladgrenzen<br>
) as foo using unique gid using srid=28992<br>
"<br>
<br>
while the following works fine:<br>
<br>
connectiontype postgis<br>
connection "..."<br>
data " rd_bnd from (<br>
select gid,bladnr,rd_bnd from tmk.bladgrenzen<br>
) as foo using unique gid using srid=28992<br>
"<br>
<br>
Don't try to spot the difference: the mailer automatically changes
tabs into blanks.<br>
<br>
If there are tabs (or newlines) around the first variable in the
data clause, the query fails: the database is queried with the tab
or newline added to the variable name and returns the error
"variable not found". In the subselect you can put as many
tabs,newlines or other whitespace as you like. <br>
<br>
If this is really an error (perhaps I am dizzy from looking for
half an afternoon at this data statement), there must be more
cases where the parser doesn't get it right. Can anyone confirm?<br>
<br>
Jan<br>
</font>
</body>
</html>