On Jan 8, 2008 8:51 AM, <[EMAIL PROTECTED]> wrote:
> DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP) > ?
>
>
>
> Here the calculated value in '?' is not supported by the postgres as it was
> set as a double.
>
> I tried to cast it to a timestamp by using Timestamp timestamp
On Tue, Jan 08, 2008 at 08:21:40PM +0530, [EMAIL PROTECTED] wrote:
> The query is something like :
>
> DELETE from CONCURRENT_USER WHERE (now() - CONCURRENT_USER.TIME_STAMP) >
> ?
>
> Here the calculated value in '?' is not supported by the postgres as it
> was set as a double.
In postgres subtr
On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 8:52 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Time stamp issue
Importance: High
Hi Everyone,
I have a table named concurrent_user which has a column time_stamp. The
column stores the timestamp for the latest en
Hi Everyone,
I have a table named concurrent_user which has a column time_stamp. The
column stores the timestamp for the latest entered record.
My query finds the difference of the timestamp from the current time, if
the value is larger than 5 minutes then the latest entered record in the
tab
On Tue, Dec 05, 2006 at 17:31:53 +0530,
deepak pal <[EMAIL PROTECTED]> wrote:
> hi can we make a field auto incrementing field using Time Stamp data type
You can use a column default that uses current_timestamp for its expression.
If you also want to handle updates or override cases where people
am Tue, dem 05.12.2006, um 17:31:53 +0530 mailte deepak pal folgendes:
> hi can we make a field auto incrementing field using Time Stamp data type
On INSERT: set the default value for this field to now()
For Update: create a trigger to do this.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz:
hi can we make a field auto incrementing field using Time Stamp data type
sh Deshmukh" <[EMAIL PROTECTED]>
To: "Richard Huxton"
Cc: "Postgresql-General"
Sent: Monday, March 21, 2005 11:38 AM
Subject: Re: [GENERAL] Time Stamp
Hi,
I want to know how long did it take for my query to run!
Thanks,
Hrishi
On Mon, 21 Mar 2005 15:57:38 +, Ri
Hi,
I want to know how long did it take for my query to run!
Thanks,
Hrishi
On Mon, 21 Mar 2005 15:57:38 +, Richard Huxton wrote:
> Hrishikesh Deshmukh wrote:
> > Hi All,
> >
> > I want to get a "timestamp" of the queries that i run!
> > Is there a builtin command to do this/ does one need
On Mon, 2005-03-21 at 09:29, Hrishikesh Deshmukh wrote:
> Hi All,
>
> I want to get a "timestamp" of the queries that i run!
> Is there a builtin command to do this/ does one need to write a
> function/stored procedure!
> Any pointers will help.
This is actually a pretty wide open question. Do y
Hrishikesh Deshmukh wrote:
Hi All,
I want to get a "timestamp" of the queries that i run!
Is there a builtin command to do this/ does one need to write a
function/stored procedure!
Any pointers will help.
You don't say where you want this "timestamp".
In psql look into "\timing" (see the man page)
Hi All,
I want to get a "timestamp" of the queries that i run!
Is there a builtin command to do this/ does one need to write a
function/stored procedure!
Any pointers will help.
Thanks,
Hrishi
---(end of broadcast)---
TIP 5: Have you checked our ex
12 matches
Mail list logo
