Fred wrote:
Dear all,
I have a syntax problem but I don't find the clue.
Actually I adapt an mySQL query to a postgreSQL but I got a message
error that I can't interpret.
SELECT g.id, t1.name, substring(g.path, 1, (6*(-1+l.id)) + 5) as
The thing that stands out to me is the syntax for the substring
function, see:
http://www.postgresql.org/docs/8.1/static/functions-string.html
Hope this helps,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
