Re: [SQL] clock command regression in pltcl?

2010-01-24 Thread Tom Lane
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

[SQL] clock command regression in pltcl?

2010-01-22 Thread Kyle Bateman
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:

Re: [SQL] clock command regression in pltcl?

2010-01-22 Thread Tom Lane
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

Re: [SQL] clock command regression in pltcl?

2010-01-22 Thread Tom Lane
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