Re: pgAggregate problem any function

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>, "Andreas Pflug" <Andreas(dot)Pflug(at)web(dot)de>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: pgAggregate problem any function
Date: 2003-09-09 09:48:03
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B5BE@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks Hiroshi, patch applied (I ran into that problem in pga2!)

Regards, Dave.

> -----Original Message-----
> From: Hiroshi Saito [mailto:saito(at)inetrt(dot)skcapi(dot)co(dot)jp]
> Sent: 09 September 2003 06:17
> To: Andreas Pflug
> Cc: pgadmin-hackers(at)postgresql(dot)org; Dave Page
> Subject: pgAggregate problem any function
>
>
> 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
>

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2003-09-09 10:01:42 Re: dlgConversion_patch
Previous Message Dave Page 2003-09-09 09:39:59 Re: binary-compatible of pgCast