You've got two columns that the system wants to call "obj_id" here. Try something like
SELECT s.obj_id AS s_obj_id, ...
That would have been elegant, but returns a 'syntax error at or near "s_obj_id"'. Hm...
Thanks, Christoph
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
