Subject | RE: [Firebird-Architect] Substring |
---|---|
Author | Claudio Valderrama C. |
Post date | 2004-10-15T04:30:40Z |
Ann W. Harrison wrote:
length, instead of making you go back 4 characters and start collecting 4
characters at most, would make you go back collecting 4 characters, then the
result would be
'ji'
C.
> Thanks Daniel,I'm tempted to say that (like some scripting languages) providing a negative
>
> One wonders why they don't allow negative lengths so
> we could have things like this...
>
> substring ('abcdefghij' from 12 for -4) => 'ij'
length, instead of making you go back 4 characters and start collecting 4
characters at most, would make you go back collecting 4 characters, then the
result would be
'ji'
C.