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?

-- 
It's odd, and a little unsettling, to reflect upon the fact that
English is the only major language in which "I" is capitalized; in many
other languages "You" is capitalized and the "i" is lower case.
		-- Sydney J. Harris

In response to

• Re: writing new regexp functions at 2007-02-02 08:15:15 from Jeremy Drake

Responses

• Re: writing new regexp functions at 2007-02-02 17:12:27 from David Fetter

pgsql-hackers by date

Next:	From: Michael Meskes	Date: 2007-02-02 09:01:26
	Subject: Re: Why is ecpg segfaulting on buildfarm member "clownfish"?
Previous:	From: NikhilS	Date: 2007-02-02 08:54:01
	Subject: Re: --enable-debug does not work with gcc

pgsql-patches by date

Next:	From: Magnus Hagander	Date: 2007-02-02 09:12:04
	Subject: pre-vcbuild win32 install docs incorrect
Previous:	From: Jeremy Drake	Date: 2007-02-02 08:15:15
	Subject: Re: writing new regexp functions