Re: [PERFORM] How to force an Index ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: [PERFORM] How to force an Index ?
Date
Msg-id 29873.1063901770@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] How to force an Index ?  (Rhaoni Chiu Pereira <rhaoni@sistemica.info>)
List pgsql-admin
Rhaoni Chiu Pereira <rhaoni@sistemica.info> writes:
> I need to know if there is a way to set the to_char output to varchar instead of
> text !

Why don't you change the datatype of ano_mes to text, instead?  It's
unlikely your application would notice the difference.  (You could set
a CHECK constraint on the length if you really want to duplicate the
behavior of varchar(6).)

Alternatively, try 7.4 beta. I believe this issue goes away in 7.4,
because varchar no longer has separate comparison operators.

Of course there's also the option of modifying to_char's result type
in pg_proc, but I won't promise that doing so wouldn't break things.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Kuhn, Dylan K (4520500D)"
Date:
Subject: Re: dump among different versions of postgreSQL
Next
From: "Chris White (cjwhite)"
Date:
Subject: Re: Testing for a record before update or insert without using a function.