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

Reply via email to