On 05/14/2014 06:11 AM, Barry Bell wrote:
> Use the cast work fine but we are using the initcap function in a lot of places
> And do not want to cast to every place.
> (Plus we use a lot of other functions that may have the same issue).
>
> You said the initcap function return "text",
> Is this a "short" text like a varchar
> Or a long text like a clob,memo etc?
This is text vs varchar(n) or char(n). I show the 'n' because in
Postgres a varchar without a length is equivalent to text. See here for
all the details:
http://www.postgresql.org/docs/9.3/interactive/datatype-character.html
>
> Barry Bell
> Senior Developer/Analyst
> Logistics
> Harte Hanks
> 1525 NW 3rd ST
> Deerfield Beach FL, 33442
> 954-429-3771 Ext 267 office
> 954-281-1464 fax
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com