Kyle Bateman k...@actarg.com writes:
Is this a regression or is there a reason the clock command is no longer
accessible?
And the answer is ... it's an underdocumented implementation change
in Tcl's clock command. You can find the explanation and patch at
I have the following function defined:
create function _date_week(int4,int4,int4) returns text language pltcl
immutable as $$
return [clock format [clock scan $2/$3/$1] -format %U]
$$;
It worked fine in 8.3 but in 8.4 now I try to build an index using the
function and get:
SQL ERROR:
Kyle Bateman k...@actarg.com writes:
I have the following function defined:
create function _date_week(int4,int4,int4) returns text language pltcl
immutable as $$
return [clock format [clock scan $2/$3/$1] -format %U]
$$;
It worked fine in 8.3 but in 8.4 now I try to build an index
I wrote:
I am not sure if this is a bug or an intentional change on their part.
Apparently clock was completely rewritten in 8.5, with a lot more
features, which could mean it's not safe anymore. But I don't see
any explicit acknowledgement in the release notes that it's now
considered