Re: 8.1 substring bug?

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Fri, 11 Nov 2005, Tom Lane wrote:
>> I was toying with the idea of making it translate instead to
>> 
>> pg_catalog.substring(foo, 1, (bar)::int4)
>> 
>> since AFAICS there isn't any other reasonable mapping once you have
>> committed to having the "1" in there.  This does not solve the general
>> problem, but it'd address the particular case anyway ...

> And, it's fairly reasonable to assume at least right now that any
> reasonable string offset or length fits in an int4.

If we thought differently we'd be changing the substring function,
and we could surely change the translation at the same time.
        regards, tom lane