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
Kyle Bateman 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 th
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
On Wed, Jan 20, 2010 at 10:13 PM, Andreas wrote:
> Thanks a whole lot and some :)
>
> It's great that you actually did a working script.
> I find it tremendosly easier to learn with a working example than with some
> links to other documentation which makes or does not make sense.
>
> I've got a
