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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
