Re: bug in substring???

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:
>
> * text_substr()
> * Return a substring starting at the specified position.
> * - thomas 1997-12-31
> *
> * Input:
> * - string
> * - starting position (is one-based)
> * - string length
> *
> * If the starting position is zero or less, then return from the start
> * of the string adjusting the length to be consistent with the
> * "negative start" per SQL92. If the length is less than zero, return
> * the remaining string.

thanks. I just got done looking up the SQL explanation, and I think my
head exploded. Thanks for the heads up.