From:
David Fetter <david(at)fetter(dot)org>
To:
Jeremy Drake <pgsql(at)jdrake(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL Hackers <pgsql-patches(at)postgresql(dot)org>
Subject:
Re: [HACKERS] writing new regexp functions
Date:
2007-02-04 15:45:28
Message-ID:
20070204154528.GB13202@fetter.org (view raw or flat )
Thread:
2007-02-01 21:20:18 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 00:41:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-02 01:11:30 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 03:29:35 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 05:11:42 from David Fetter <david(at)fetter(dot)org>
2007-02-02 06:16:54 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 06:55:18 from David Fetter <david(at)fetter(dot)org>
2007-02-02 08:15:15 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 08:54:30 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-02 17:12:27 from David Fetter <david(at)fetter(dot)org>
2007-02-03 00:59:54 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-03 01:56:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-03 02:03:13 from David Fetter <david(at)fetter(dot)org>
2007-02-03 03:01:33 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-04 15:45:28 from David Fetter <david(at)fetter(dot)org>
2007-02-04 21:00:12 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-07 08:26:00 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-07 14:23:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-07 19:07:30 from David Fetter <david(at)fetter(dot)org>
2007-02-08 00:20:25 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-09 03:22:58 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-09 03:35:52 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-09 03:39:04 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-09 03:46:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-09 09:08:57 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-09 22:46:06 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-10 00:33:38 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-10 06:57:46 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-10 08:33:59 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-10 09:26:00 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-11 00:08:33 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-15 00:49:32 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-15 02:10:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-15 05:50:08 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-15 08:22:27 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-15 08:56:06 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-15 09:57:45 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-15 15:34:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-15 20:10:56 from David Fetter <david(at)fetter(dot)org>
2007-02-15 13:55:35 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-15 15:37:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-15 15:56:25 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-15 16:57:09 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-16 07:02:33 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-16 12:19:55 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-16 16:11:21 from David Fetter <david(at)fetter(dot)org>
2007-02-16 16:54:47 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-16 17:49:36 from David Fetter <david(at)fetter(dot)org>
2007-02-16 18:03:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-02-16 18:28:39 from David Fetter <david(at)fetter(dot)org>
2007-02-16 18:19:54 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-16 23:18:15 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-17 08:02:24 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-17 08:16:06 from David Fetter <david(at)fetter(dot)org>
2007-02-17 09:20:08 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-17 16:19:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-17 19:32:58 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-17 19:43:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-18 00:10:20 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-18 06:15:43 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-18 17:32:41 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-18 20:03:35 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-18 23:10:51 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-18 23:27:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-18 23:56:08 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-20 22:18:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-18 05:47:07 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-18 05:49:30 from Neil Conway <neilc(at)samurai(dot)com>
2007-03-20 21:19:05 from Neil Conway <neilc(at)samurai(dot)com>
2007-03-21 05:50:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-21 06:12:55 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-21 12:34:12 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-21 12:51:38 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-22 05:17:03 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-22 05:32:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-22 05:47:44 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-27 00:52:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-27 02:03:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-27 02:09:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-27 02:18:38 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-27 13:56:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-21 13:45:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-22 00:09:22 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-22 04:42:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-22 05:21:28 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-27 13:56:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-28 19:00:22 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-03-28 21:09:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-28 23:00:32 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-17 08:23:17 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-17 17:12:54 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-17 19:27:06 from Mark Dilger <pgsql(at)markdilger(dot)com>
2007-02-15 17:02:58 from David Fetter <david(at)fetter(dot)org>
2007-02-16 00:35:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-16 00:59:15 from David Fetter <david(at)fetter(dot)org>
2007-02-16 01:20:52 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-02-15 23:15:31 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-07 20:34:23 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2007-02-07 20:37:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers pgsql-patches
On Fri, Feb 02, 2007 at 07:01:33PM -0800, Jeremy Drake wrote:
> Let me know if you see any bugs or issues with this code, and I am
> open to suggestions for further regression tests ;)
> Things that I still want to look into:
> * regexp flags (a la regexp_replace).
One more text field at the end is how the regexp_replace() one does
it.
> * maybe make regexp_matches return setof whatever, if given a 'g' flag
> return all matches in string.
This is doable with current machinery, albeit a little clumsily.
> * maybe a join function that works as an aggregate
> SELECT join(',', col) FROM tbl
> currently can be written as
> SELECT array_to_string(ARRAY(SELECT col FROM tbl), ',')
The array_accum() aggregate in the docs works OK for this purpose.
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
In response to
Responses
pgsql-hackers by date
Next :From: Theo SchlossnagleDate: 2007-02-04 15:53:32Subject : Re: Proposal: Commit timestampPrevious :From : Jan WieckDate : 2007-02-04 15:06:27Subject : Re: Proposal: Commit timestamp
pgsql-patches by date
Next :From: Tom LaneDate: 2007-02-04 17:32:32Subject : Re: [BUGS] BUG #2221: Bad delimiters allowed in COPY ... Previous :From : Pavel StehuleDate : 2007-02-04 15:19:33Subject : TM formating patch
