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