Calling overloaded function with NULL argument

From: Patryk Kordylewski <pk(at)fooby(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Calling overloaded function with NULL argument
Date: 2009-02-09 20:15:32
Message-ID: 49908EE4.5050601@fooby.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i've found a strange behaviour when you have overloaded functions with
the same name and different argument types and try to call them with NULL.
The stored procedures with "text" and "text[]" argument type gets called
- the variants with "integer" / "integer[]" produce the, i think
expected, behaviour and raise an exception "ERROR: FUNCTION
foo(unknown) IS NOT UNIQUE".

Is there an explanation or is this a bug?

I've tested this on PG 8.3.1 and 8.2.4, see
http://pgsql.privatepaste.com/2bCQg0FEPX

Best regards,
Patryk Kordylewski

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2009-02-09 20:15:38 Re: Out of memory on SELECT in 8.3.5
Previous Message Matt Magoffin 2009-02-09 20:06:56 Re: Out of memory on SELECT in 8.3.5