Postgres Pro
Downloads
Home   >   mailing lists

query - Mailing list pgsql-sql

From Chandan_Kumaraiah
Subject query
Date
Msg-id 2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com
Whole thread Raw
Responses Re: query  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-sql
Tree view 
<div class="Section1"><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: "mroyce@gmail.com"
Date:
Subject: timestamp precision - can I control precision at select time or set for all time?
Next
From: Jonathan Daugherty
Date:
Subject: Re: tablename as function parameter