On 07/08/2010 20:40, aravind chandu wrote:
condition in where clause : table.date in date() to date() and table.item = "laptop" and table.item = "Desktop"
I don't think this is correct - you need "BETWEEN". Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general