On Fri, Feb 02, 2007 at 12:54:30AM -0800, Jeremy Drake wrote:
> On Fri, 2 Feb 2007, Jeremy Drake wrote:
>
> > jeremyd=# select * from regexp_matches('foobarbequebaz',
> > $re$(bar)(beque)$re$, false);
> > prematch | fullmatch | matches | postmatch
> > ----------+-----------+-------------+-----------
> > \N | \N | {bar,beque} | \N
> > (1 row)
>
> I just changed this to fill in fullmatch when the bool is false, so this
> one would look like:
> prematch | fullmatch | matches | postmatch
> ----------+-----------+-------------+-----------
> \N | barbeque | {bar,beque} | \N
> (1 row)
>
> I also removed my check for capture groups, since in this setup you could
> get useful output without any. I am still trying to decide whether or not
> to add back an error if you called the no-bool version which just returns
> the array, and you do not have any capture groups. ISTM this is likely an
> oversight on the query author's part, and it would be helpful to alert him
> to this.
>
> If you have no capture groups, the matches array is empty (not null). If
> the match happened at the start of the string, the prematch is an empty
> string, and if the match happened at the end of the string, the postmatch
> is an empty string.
>
> > Reasonable?
This is great :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
