From: John Gage <jsmgage@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: window function to sort times series data?
Date: Wed, 24 Mar 2010 19:38:27 +0100
Message-ID: <cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com> (raw)
In-Reply-To: <20100324140832.GA5864@apartia.fr>
References: <20100324140832.GA5864@apartia.fr>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jsmgage@gmail.com
Subject: Re: window function to sort times series data?
In-Reply-To: <cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox