[gnome-db] sql statement not parsed correctly (postgresql)
- From: Andrea Zagli <azagli libero it>
- To: "gnome-db-list gnome org" <gnome-db-list gnome org>
- Subject: [gnome-db] sql statement not parsed correctly (postgresql)
- Date: Thu, 06 Oct 2011 10:33:32 +0200
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]