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



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
thanks in advance



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]