On Wed, Dec 03, 2003 at 05:59:25PM +1100, Gavin Sherry wrote: > On Wed, 3 Dec 2003, Christopher Kings-Lynne wrote: > > > > > > + SELECT 'epoch'::timestamp + '1070430858 seconds'::interval; > > > + <lineannotation>Result: </lineannotation><computeroutput>2003-12-03 > > > 05:54:18</computeroutput> > > > </screen> > > > > You could also go: > > > > SELECT '1070430858'::abstime; > > > > But your way is probably a bit more stable...dunno... > > template1=# SELECT '1070430858'::abstime; > ERROR: invalid input syntax for type abstime: "1070430858" > > I agree its more stable :-). That's on HEAD. > > Gavin
I like "more stable." "Clearer" is good, too :) :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend