Re: 8.1 substring bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.1 substring bug?
Date
Msg-id 20154.1131731053@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.1 substring bug?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: someone working to add merge?
Next
From: Csaba Nagy
Date:
Subject: Re: someone working to add merge?