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 using the > function and get: > (empl_id,(date_week(wdate)));: ERROR: invalid command name "clock" Are you using the same underlying version of tcl as before? What I'm seeing is that tcl seems to have dropped "clock" from the set of commands considered "safe" between tcl 8.4 and 8.5 --- with 8.5 you can only get at it in pltclu. The version of PG isn't relevant. 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 unsafe. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql