Postgres Pro
Downloads
Home   >   mailing lists

Using AND in query - Mailing list pgsql-general

From aravind chandu
Subject Using AND in query
Date
Msg-id 853899.68325.qm@web31405.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Using AND in query
Re: Using AND in query
Re: Using AND in query
List pgsql-general
Tree view
Hello every one,
 
I have encountered a problem while working .I have a sample table with the following data
 
 
TIDDateItem
T1008/1/2010Laptop
T1008/1/2010Desktop
T1018/1/2010Laptop
T1028/1/2010Desktop
T1038/2/2010Laptop
T1038/2/2010Desktop
T1048/2/2010Laptop

 

need the data when a person bought laptop & desktop on the sameday.I used a condition in where clause but its not working,it is returning no rows.Can any one please help me to resolve this issue ?

 
condition in where clause :
table.date in date() to date() and table.item = "laptop" and table.item = "Desktop"
 

pgsql-general by date:

Previous
From: PIC2010
Date:
Subject: 2010 International Conference on Progress in Informatics and Computing(PIC-2010 )
Next
From: Raymond O'Donnell
Date:
Subject: Re: Using AND in query