Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> COMMENT ON AGGREGATE newcnt (any) IS 'an any agg comment';
> ERROR: syntax error at or near "any" at character 30
ANY is a reserved word. To reference the pseudotype named "any",
you need quotes:
COMMENT ON AGGREGATE newcnt ("any") IS
-- value-independent transition function
CREATE AGGREGATE newcnt (
sfunc = int4inc, basetype = 'any', stype = int4,
initcond = '0'
);
COMMENT ON AGGREGATE newcnt (any) IS 'an any agg comment';
ERROR: syntax error at or near "any" at character 30
COMMENT ON AGGREGATE newcnt (any) IS NULL;
ERR