How to select where .... - Mailing list pgsql-general

From Edouard DESSIOUX
Subject How to select where ....
Date
Msg-id 99120610214603.02757@dooz.corp.intrinsec.com
Whole thread Raw
List pgsql-general
Hello,

I've encountered a pb while making a simple request :
A have a field date whose type is timestamp and I would like
to make a select like :
select * from truc
where date > (current_timestamp - 10 days)

Anyone know how I could perform such a query

Txs

--
Edouard DESSIOUX
Proverbe chien :
"Si ca se mange pas,
 Si ca se baise pas,
 Pisse dessus !!"

pgsql-general by date:

Previous
From: admin
Date:
Subject: WaitOnLock error on wakeup
Next
From: frédérik GUITTON
Date:
Subject: PostGres ODBC Drivers