DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=nJIl9ZjfbZxG4VgzK2hmCyB65lyM0kg/aalUpPkdpltMdj/tPSeb+/1U+IJoiW5vGC
	P5vzyJ4fwsSjbDYG1BIZMNvRfszAhQ9elqsRqSj7R928ybv3NaHhfJkX1GSOWSsAb5xh
	92JLHT/fZCZnvdkSRlyee8Yhlsxjo/bGUsQLE=
MIME-Version: 1.0
In-Reply-To: <cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com>
References: <20100324140832.GA5864@apartia.fr>
	<cd15286d1003241138i486a4139ha66c5d57ab8a196c@mail.gmail.com>
From: Josh Kupershmidt <schmiddy@gmail.com>
Date: Wed, 24 Mar 2010 15:13:24 -0400
Message-ID: <4ec1cf761003241213p26d5bccesdaf5283dda2725ca@mail.gmail.com>
Subject: Re: window function to sort times series data?
To: John Gage <jsmgage@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

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