Regexp matching: bug or operator error?

From: Ken Tanzer <ktanzer(at)desc(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Regexp matching: bug or operator error?
Date: 2004-11-23 23:24:54
Message-ID: 41A3C6C6.2090605@desc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Using Postgres V. 7.4.1, the following query:

SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');

Returns '1'. I would expect it to return '12345'. Is this a bug, or am
I missing something? Thanks.

Attachment Content-Type Size
ktanzer.vcf text/x-vcard 300 bytes

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thomas Hallgren 2004-11-23 23:41:26 Re: Regexp matching: bug or operator error?
Previous Message ISHIKAWA Toshiyuki 2004-11-23 11:44:18 合宿とかのスケジュール

Browse pgsql-general by date

  From Date Subject
Next Message Gary L. Burnore 2004-11-23 23:30:57 Re: Upcoming Changes to News Server ...
Previous Message Peter Eisentraut 2004-11-23 23:22:45 Re: Upcoming Changes to News Server ...