[GENERAL] change the order of FROM selection to make query work

hi, posted this twice allready, but didn't seem to make it to the list. so one more try: i support a trac [1] installation and migrated the backend from sqlite to postgres 8.1.4, which worked fine, but: the following sql stopped working with postgres, and the fix of this problem seems strange to m

Re: [GENERAL] change the order of FROM selection to make query work

Am 26.9.2006 schrieb "Tom Lane" <[EMAIL PROTECTED]>: >> FROM ticket as t, permission as perm, enum as p >> LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = >> 'fachabteilung') > >The above is, plain and simple, wrong. According to the SQL spec, >JOIN binds more tightly than comma i

Re: [GENERAL] change the order of FROM selection to make query work

Am 26.9.2006 schrieb "Tom Lane" <[EMAIL PROTECTED]>: >Define "stopped working" ... what was wrong exactly? oh, sorry. i forgot the error message: Error: org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry for table "t", SQL State: 42P01, Error Code: 0 (i use squirrel

[GENERAL] strange sql issue

hi, i support a trac [1] installation and changed the backend from sqlite to postgres 8.1.4 the following sql stopped working with postgres, and the fix of this problem seems strange to me. first the old sql, that worked with sqlite: SELECT p.value AS __color__, id AS ticket, summary, status, prio