"scott.marlowe" <[EMAIL PROTECTED]> writes:
> thanks. I just got done looking up the SQL explanation, and I think my
> head exploded. Thanks for the heads up.
The formal definition seems unnecessarily complicated :-(, but the spec
authors' intent is reasonably clear from this paragraph in the
"
On Fri, 6 Feb 2004, Joe Conway wrote:
> scott.marlowe wrote:
> > gives me nothing. Shouldn't a negative offset, or even 0 offset result in
> > an error or something here? Or is there a special meaning to a negative
> > offset I'm not getting?
>
> In varlena.c there is this comment:
>
> * t
scott.marlowe wrote:
gives me nothing. Shouldn't a negative offset, or even 0 offset result in
an error or something here? Or is there a special meaning to a negative
offset I'm not getting?
In varlena.c there is this comment:
* text_substr()
* Return a substring starting at the specified po
I'm using substring. Since I'm a coder more than a database guy, I
expected this:
select substring('abcdefgh',0,4);
would give me
abcd
but it gives me a left aligned 'abc'
select substring('abcdefgh',1,4);
works fine.
select substring('abcdefgh',-4,4);
gives me nothing. Shouldn't a nega