Re: window function to sort times series data?

From: John Gage <jsmgage(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: window function to sort times series data?
Date: 2010-03-24 18:38:27
Message-ID: cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message John Gage 2010-03-24 18:58:28 Help with reg_exp
Previous Message Louis-David Mitterrand 2010-03-24 16:49:37 Re: window function to sort times series data?