David Shadovitz wrote:
>I've created two PL/pgSQL functions with the same name and different
>signatures:
>
>CREATE FUNCTION ABC(CHAR) ...
>CREATE FUNCTION ABC(TEXT) ....
>
>I intended to call the CHAR-signature function like this:
>SELECT ABC('R');
>
>And the TEXT-signature function like this:
>SELECT ABC('Right');
>
>But I found that both calls invoke the TEXT-signature function.
>
maybe you need to do this:
SELECT ABC('R':TEXT);
SELECT ABC('Right':CHAR);