Help with reg_exp

From: John Gage <jsmgage(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help with reg_exp
Date: 2010-03-24 18:58:28
Message-ID: cd15286d1003241158l53822e8cvd554ead33869cfa9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

[I mistakenly used the wrong Subject line initially with this post]

In going through the arcana of string functions, I have come across the
following series of selects that contain, for me, a mysterious "$re$".

-- return all matches from regexp
SELECT regexp_matches('
foobarbequebaz', $re$(bar)(beque)$re$);

-- test case insensitive
SELECT regexp_matches('foObARbEqUEbAz', $re$(bar)(beque)$re$, 'i');

-- global option - more than one match
SELECT regexp_matches('foobarbequebazilbarfbonk', $re$(b[^b]+)(b[^b]+)$re$,
'g');

When I run this I get:

regexp_matches
--------------------------
<Unknown(2,003)>

I have not been able to find out what it all means. Forgive me for my
blindness.

John

P.S. The author of the statements is "alexk" at Command Prompt. They are
test statements against Postgres' string functions.

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Kupershmidt 2010-03-24 19:13:24 Re: window function to sort times series data?
Previous Message John Gage 2010-03-24 18:38:27 Re: window function to sort times series data?