timestamp v posgresql

[Karel Zak]

On Thu, Jul 18, 2002 at 11:58:26AM +0200, Radek Kanovsky wrote:
> On Thu, Jul 18, 2002 at 11:45:36AM +0200, Karel Zak wrote:
> >  V 7.2 by to melo jit trosku vice primocare:
> > 
> > test=# SELECT 'epoch'::timestamp + 1026985310.20481::interval;
> >            ?column?           
> > ------------------------------
> >  2002-07-18 11:41:50.20481+02
> > 
> >  na misto toho cisla si muzete dat ten sloupecek.
> 
> Nevim jak vam, ale mne to fachci tak napul:
> test=# SELECT 'epoch'::timestamp + u::interval FROM t;
> ERROR:  Cannot cast type 'integer' to 'interval'
> 
> 
> test=# SELECT 'epoch'::timestamp + 1026985310.20481::interval;
>            ?column?           
> ------------------------------
>  2002-07-18 11:41:50.20481+02
> (1 row)
> 

 Sorry, mate pravdu pretypovani cislo->interval nejde primo. Vyse
 uvedene slo protoze PostgreSQL to bere jako nejakou konstantu, ktera
 je asi interne textova.

 Takze pokud to je sloupec s int4 (apod.) tak je to spravne jak jste
 to psal vy tedy int4->text->interval.

> test=# SELECT 'epoch'::timestamp + (u::text)::interval FROM t;


    Karel

-- 
 Karel Zak  <zakkr na zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz