Re: [gnome-db] sql statement not parsed correctly (postgresql)

[Vivien Malerba <vmalerba gmail com>]

On 6 October 2011 10:33, Andrea Zagli <azagli libero it> wrote:

this sql

(SELECT data FROM mezzo_chilometraggi
WHERE status <> 'E' AND id_mezzi = 4 AND data = "" 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