Re: CHAR vs TEXT args - Mailing list pgsql-general

From Dennis Gearon
Subject Re: CHAR vs TEXT args
Date
Msg-id 3F4E0A1E.6050500@fireserve.net
Whole thread Raw
In response to CHAR vs TEXT args  (david_shadovitz@xontech.com (David Shadovitz))
List pgsql-general
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);




pgsql-general by date:

Previous
From: Chris Webster
Date:
Subject: Re: Books for PostgreSQL?
Next
From: Dennis Gearon
Date:
Subject: Re: Books for PostgreSQL?