[SQL] bigint and unix time

2011-08-14 Thread Janiv Ratson
Hi, I have the following query: select ticket as ticket, time as created, author as reporter, cast(extract(epoch from (date 'now' - integer '30')) as bigint) from ticket_change tc where field = 'status' and newvalue = 'reopened' and time > extract(epoch from (date 'now' - integer '30')

Re: [SQL] pgadmin debugger

2011-08-14 Thread David Harel
On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote: > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: > > Greetings, > > > > I use Ubuntu 10.04. I have postgresql version 8.4.8 installed also I > > have pgadmin version 1.10.2. I can't find debugger_plugin.so which is > > needed to

Re: [SQL] bigint and unix time

2011-08-14 Thread Adrian Klaver
On Sunday, August 14, 2011 4:13:30 am Janiv Ratson wrote: > Hi, > > > > I have the following query: > > > > select ticket as ticket, time as created, author as reporter, > cast(extract(epoch from (date 'now' - integer '30')) as bigint) > > from ticket_change tc > > where field = 'status' >

Re: [SQL] pgadmin debugger

2011-08-14 Thread Adrian Klaver
On Sunday, August 14, 2011 10:15:43 am David Harel wrote: > On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote: > > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: > > > Greetings, > > > > > > I use Ubuntu 10.04. I have postgresql version 8.4.8 installed also I > > > have pgadmin v

Re: [SQL] pgadmin debugger

2011-08-14 Thread David Harel
On Sun, 2011-08-14 at 11:07 -0700, Adrian Klaver wrote: > On Sunday, August 14, 2011 10:15:43 am David Harel wrote: > > On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote: > > > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: > > > > Greetings, > > > > > > > > I use Ubuntu 10.04. I