Postgres Pro
Downloads
Home   >   mailing lists

Re: Using AND in query - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Using AND in query
Date
Msg-id 4C5DCBDE.7010903@iol.ie
Whole thread Raw
In response to Using AND in query  (aravind chandu <avin_friends@yahoo.com>)
List pgsql-general
Tree view 
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@iol.ie

pgsql-general by date:

Previous
From: aravind chandu
Date:
Subject: Using AND in query
Next
From: Thomas Kellerer
Date:
Subject: Re: Using AND in query