Hi,
I see it work without quotes around function,
but I got it from a 7.2 dump with quotes around it.
Maybe it require a note for people dumping from 7.2,
I don't have 7.3 around to try, sorry
bye
Giuseppe Tanzilli - CSF wrote:
> Hi,
> just testing beta2 I got strange things on default values with functions:
>
> create table test2 (i integer, t timestamp default 'now()');
>
> test1=# \d test2
> Table "public.test2"
> Column | Type |
> Modifiers
> --------+-----------------------------+-------------------------------------------------------------------
>
> i | integer |
> t | timestamp without time zone | default '29/08/2003
> 11:26:23.937421'::timestamp without time zone
>
>
> test1=# insert into test2 values(1);
> INSERT 9841455 1
> test1=# insert into test2 values(1);
> INSERT 9841456 1
> test1=# insert into test2 values(1);
> INSERT 9841457 1
>
> test1=# select * from test2;
> i | t
> ---+----------------------------
> 1 | 29/08/2003 11:26:23.937421
> 1 | 29/08/2003 11:26:23.937421
> 1 | 29/08/2003 11:26:23.937421
> (3 rows)
>
>
> Seems that functions are valuated when the table is created,
> It is a known change or a bug ?
>
> thanks,
> Giuseppe
>
>
>
--
-------------------------------------------------------
Giuseppe Tanzilli g.tanzilli@gruppocsf.com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy