Syntax problem for a newbie

From: "Fred" <frederic(dot)fleche(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Syntax problem for a newbie
Date: 2006-05-05 10:03:50
Message-ID: 1146823430.885013.124890@j33g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
subpath,l.id-1 as level
FROM graph_path g
INNER JOIN term AS t1
INNER JOIN term AS t2 ON (t2.id = g.term2_id)
INNER JOIN levels l ON (substring(path, 1+(6*(-1+l.id)), 5) = t1.id
AND g.distance+1 >= l.id)
WHERE t2.name = 'blood_coagulation' and g.term1_id=1
ORDER BY g.id, subpath;

ERROR: syntax error at or near "WHERE" at character 284
LINE 7: WHERE t2.name = 'blood_coagulation' and g.term1_id=1

Let me know if you need details concerning the tables but I don't think
it is necesseray.
Hopefully I did a newbie mistake.

Thanks in advance,

Fred

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2006-05-05 11:06:46 Re: Function query plan
Previous Message robert 2006-05-05 09:22:32 simple md5 authentication problems