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);
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
