Hi Bruno What version of soci are you using ?
It looks a bit like the Postgres regression that went into 3.2.0 See commit c8ad2a884 for details. It should be fixed in 3.2.1. Poul > I tried with the escape beckslash \ (that is \:\:box3d) but the error was > the same. > Then I tried to change the cast syntax as suggested by Mateusz and the > query worked. > Could be a good idea to add an escape strategy like that one of the > backslash (\) for parsing the colons. > Do I add the feature request on github? > > thanks for the replies, > Bruno > > > 2013/4/6 Vadim Zeitlin <[email protected]> > >> On Sat, 6 Apr 2013 14:02:09 +0100 Mateusz Loskot <[email protected]> >> wrote: >> >> ML> > the application gives my the following error: >> ML> > >> ML> > "Wt: fatal error: ERROR: syntax error at or near ""$1"" >> ML> > LINE 1: ...etsrid('BOX3D(15.0118 37.4667, 15.2118 37,6667)'::$1, >> 4326) ... >> ML> > >> ML> > the error is given in place of $1 that in the query is ::box3d. >> Why? >> there >> ML> > was this traslation? >> ML> >> ML> I haven't tested your query in action, but I suppose there may be >> conflict >> ML> between casting operators and how SOCI parses query to handle >> ML> placeholders bound by name: >> ML> >> ML> http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name >> >> FWIW the code in PostgreSQL backend clearly tries to detect the cast >> operators, there are even several cases for this there. >> >> ML> > Maybe is the double colons that gives the problem? How >> ML> > I can fix? How to pass a colon in the sql string? >> ML> >> ML> Can you try the alternative [1], SQL conformant, syntax for the >> cast: >> ML> >> ML> SetSRID(CAST('BOX3D(15.0118 37.4667, 15.2118 37,6667)' AS box3d), >> 4326) >> >> From reading the code, it also looks like you should be able to use a >> backslash to escape (each) colon. But I haven't tested this myself. >> >> Regards, >> VZ >> >> >> ------------------------------------------------------------------------------ >> Minimize network downtime and maximize team effectiveness. >> Reduce network management and security costs.Learn how to hire >> the most talented Cisco Certified professionals. Visit the >> Employer Resources Portal >> http://www.cisco.com/web/learning/employer_resources/index.html >> _______________________________________________ >> soci-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/soci-users >> >> > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html_______________________________________________ > soci-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/soci-users > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
