Home > mailing lists

query - Mailing list pgsql-sql

From	Chandan_Kumaraiah
Subject	query
Date	March 17, 2005 11:08:39
Msg-id	2EB549AAAFEA264FA926269A5BD5E9EB146579@certsrv.satyam.com Whole thread Raw
Responses	Re: query
List	pgsql-sql

Hi,

In oracle we write sysdate-1

For example,we write a query (select * from table1 where created_date>=sysdate-1).Whats its equivalent in postgre?

Chandan

pgsql-sql by date:

From: "Tambet Matiisen"
Date: 17 March 2005, 08:39:59
Subject: Re: How to force subquery scan?

From: PFC
Date: 17 March 2005, 11:20:20
Subject: Re: Query performance problem