Oops - Stupid mistake.
I thought i had filtered put all of the nulls and blank entries
from the source table, but I hadn't. Of course the match doesn't work
on a blank entry.
the user-defined aggregate functions do work properly, and as
expected. Sorry to trouble everyone.
--
Karl DeBissc
is it possible to use more than one user-defined aggregate function in
a single SELECT?
I have defined a function uid2int in pltcl to convert a string to an
integer representation.
CREATE FUNCTION uid2int4 (bpchar) RETURNS int4 AS '
regexp {([A-Z]*)0*([0-9]+)([A-Z]*)} $1 match pre num pst
if
