Re: [gnome-db] sql statement not parsed correctly (postgresql)
Vivien Malerba <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <CAEP1ZNn=2wJBK1sbsumDfkqixRgZ7mExbvNi8Xdg3y_fpKy52g@mail.gmail.com> |
On 6 October 2011 10:33, Andrea Zagli <[email protected]> wrote: > this sql > > (SELECT data FROM mezzo_chilometraggi > WHERE status <> 'E' AND id_mezzi = 4 AND data = '2011-01-01' LIMIT 1) > UNION > (SELECT data FROM mezzo_chilometraggi > WHERE status <> 'E' AND id_mezzi = 4 AND data < '2011-01-01' ORDER BY data > DESC LIMIT 1) > > is not parsed correctly; the result is without parenthesis that delimit > queries before and after union > > I understand you mean the SQL rendering is not correct, but the parsiing itself is correct. Is that right? Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list