On Thu, May 06, 2010 at 07:02:55AM +0100, Cooke, Mark wrote: > > > > select id from ticket where current_timestamp - (timestamp with > > time zone 'epoch' + time * interval '1 sec') < interval '24 hours'; > > > ...that doesn't look like real sql to me... Could you possible provide a > working example as I have never managed to get this sort of query to > work. >
Well, you need to adjust your sense of 'what looks like real SQL' then: that's a working example cut and paste directly from a psql prompt connected to my own trac install. Ross -- Ross Reedstrom, Ph.D. [email protected] Systems Engineer & Admin, Research Scientist phone: 713-348-6166 The Connexions Project http://cnx.org fax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
