| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Harald Fuchs <hf0923x(at)protecting(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 8.1 substring bug? |
| Date: | 2005-11-11 17:44:13 |
| Message-ID: | 20154.1131731053@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2005-11-11 17:48:33 | Re: someone working to add merge? |
| Previous Message | Tom Lane | 2005-11-11 17:39:39 | Re: someone working to add merge? |