From: Josh Kupershmidt <schmiddy@gmail.com>
To: John Gage <jsmgage@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: window function to sort times series data?
Date: Wed, 24 Mar 2010 15:13:24 -0400
Message-ID: <4ec1cf761003241213p26d5bccesdaf5283dda2725ca@mail.gmail.com> (raw)
In-Reply-To: <cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com>
References: <20100324140832.GA5864@apartia.fr>
<cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com>
On Wed, Mar 24, 2010 at 2:38 PM, John Gage <jsmgage@gmail.com> wrote:
> 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$);
The $re$ is just an arbitrary identifier for a dollar-quoted string
constant. See:
http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html
Maybe you're on an old version which doesn't support dollar-quoted strings?
On 8.3 for the above query, I get:
SELECT regexp_matches('foobarbequebaz', $re$(bar)(beque)$re$);
regexp_matches
----------------
{bar,beque}
(1 row)
Josh
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: schmiddy@gmail.com, jsmgage@gmail.com
Subject: Re: window function to sort times series data?
In-Reply-To: <4ec1cf761003241213p26d5bccesdaf5283dda2725ca@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