Re: [ANNOUNCE] == PostgreSQL Weekly News - February 11 2007 ==

I made some notes about what you said about my patch, just so that I can
be sure that it is clear what it does.

On Sun, 11 Feb 2007, David Fetter wrote:

> == PostgreSQL Weekly News - February 11 2007 ==
>
> == Pending Patches ==
>
> Jeremy Drake sent in a patch which implements regexp_replace with
> multiple atoms,

I don't know what you mean here.  The only change I made to
regexp_replace was fairly incedental: I split out the flag parsing code
so that regexp_matches and regexp_split could use it as well, and in the
process added support for some new flags which before could only be
specified using the metasyntax
(http://developer.postgresql.org/pgdocs/postgres/functions-matching.html#POSIX-METASYNTAX).
Also, the error message for invalid flags to regexp_replace changed.  I
did not touch anything relating to what atoms are allowed
(http://developer.postgresql.org/pgdocs/postgres/functions-matching.html#POSIX-ATOMS-TABLE).

> regexp_matches, a set-returning function, and
> regexp_split.  Perl weenies rejoice!

regexp_matches will only return a set if the 'g' flag was given.  The
no-flags version is not even declared as set-returning, it just returns a
straight text[].  regexp_split is more of a set-returning function... :)

-- 
The human mind ordinarily operates at only ten percent of
its capacity -- the rest is overhead for the operating system.