Postgres Pro
Downloads
Home   >   mailing lists

query - Mailing list pgsql-sql

From Chandan_Kumaraiah
Subject query
Date
Msg-id 2EB549AAAFEA264FA926269A5BD5E9EB146579@certsrv.satyam.com
Whole thread Raw
Responses Re: query  (Terry Fielder <terry@ashtonwoodshomes.com>)
List pgsql-sql
Tree view 
<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">Hi,</span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">In oracle we write sysdate-1</span></font></b><p class="MsoNormal"><b><font
face="Tahoma"size="2"><span style="font-size:10.0pt; 
font-family:Tahoma;font-weight:bold">For example,we write a query (select * from table1 where
created_date>=sysdate-1).Whatsits equivalent in postgre?</span></font></b><p class="MsoNormal"><b><font
face="Tahoma"size="2"><span style="font-size:10.0pt; 
font-family:Tahoma;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">Chandan</span></font></b><p class="MsoNormal"><b><font face="Tahoma"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Tahoma;font-weight:bold"> </span></font></b></div>

pgsql-sql by date:

Previous
From: "Tambet Matiisen"
Date:
Subject: Re: How to force subquery scan?
Next
From: PFC
Date:
Subject: Re: Query performance problem