Thread: BUG #3966: problem with implicit cast array parameter

The following bug has been logged online:

Bug reference:      3966
Logged by:          Pawel Kasperek
Email address:      pcasper@wp.pl
PostgreSQL version: 8.3
Operating system:   openSuse 10.3
Description:        problem with implicit cast array parameter
Details:

In PostgreSQL 8.2 I can call function: test_func(p1 text[]) as "PERFORM
test_func(ARRAY[0,1])". The server could be implicit cast array of integer
elements to array  of text. In PostgreSQL 8.3 I have error: function
test_func(integer[]) does not exist. For me problem is missed implicit
casting elements of array to text type.

"Pawel Kasperek" <pcasper@wp.pl> writes:
> In PostgreSQL 8.2 I can call function: test_func(p1 text[]) as "PERFORM
> test_func(ARRAY[0,1])". The server could be implicit cast array of integer
> elements to array  of text. In PostgreSQL 8.3 I have error: function
> test_func(integer[]) does not exist. For me problem is missed implicit
> casting elements of array to text type.

This is not a bug, it's an intentional change; see the 8.3 release
notes.

            regards, tom lane