Re: [GENERAL] CHAR vs TEXT args

2003-08-28 Thread Dennis Gearon
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('Rig

[GENERAL] CHAR vs TEXT args

2003-08-28 Thread David Shadovitz
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 th