pgAggregate problem any function

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: "Andreas Pflug" <Andreas(dot)Pflug(at)web(dot)de>
Cc: <pgadmin-hackers(at)postgresql(dot)org>, "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Subject: pgAggregate problem any function
Date: 2003-09-09 05:17:13
Message-ID: 029f01c37691$a0bc8230$1f324d80@w2k
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Andreas.

There is a problem by handling of any of the input type.

This patch will just be able to do it.
any -> "any"

But,
Is it likely to be the problem of parser of postgresql?
"ANY" is written in the document.
But, drop isn't made though "ANY" can be registered.

This is with psql.
saito=# DROP AGGREGATE public.newcnt(any);
ERROR: syntax error at or near "any" at character 30
saito=# DROP AGGREGATE public.newcnt(ANY);
ERROR: syntax error at or near "ANY" at character 30
saito=# DROP AGGREGATE public.newcnt("ANY");
ERROR: type "ANY" does not exist
saito=# DROP AGGREGATE public.newcnt("any");
DROP AGGREGATE

Any Comment?

Regards,
Hiroshi Saito

Attachment Content-Type Size
pgAggregate_patch3 application/octet-stream 1.0 KB

Browse pgadmin-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2003-09-09 07:00:46 dlgConversion_patch
Previous Message Hiroshi Saito 2003-09-09 02:49:14 binary-compatible of pgCast