Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 962581337B39 for ; Tue, 22 Feb 2011 07:25:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 09969-10 for ; Tue, 22 Feb 2011 11:25:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.scanlab.de (mail.scanlab.de [62.138.55.241]) by mail.postgresql.org (Postfix) with ESMTP id 22B671336B42 for ; Tue, 22 Feb 2011 07:25:06 -0400 (AST) Received: from unknown (HELO Exchange-Server.scanlab-intern.de) ([172.16.20.15]) by mail.scanlab-intern.de with ESMTP; 22 Feb 2011 12:25:04 +0100 Received: from Exchange-Server.scanlab-intern.de ([127.0.0.1]) by Exchange-Server ([127.0.0.1]) with mapi; Tue, 22 Feb 2011 12:25:04 +0100 From: Andreas Gaab To: pgsql sql Date: Tue, 22 Feb 2011 12:25:03 +0100 Subject: replace_matches does not return {null} Thread-Topic: replace_matches does not return {null} Thread-Index: AcvSgyXw3debfHD1SnmkA0AklSUAPg== Message-ID: <48DA836F3865C54B8FBF424A3B775AF6671A68395D@Exchange-Server> Accept-Language: de-DE Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: de-DE Content-Type: multipart/alternative; boundary="_000_48DA836F3865C54B8FBF424A3B775AF6671A68395DExchangeServe_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/106 X-Sequence-Number: 35182 --_000_48DA836F3865C54B8FBF424A3B775AF6671A68395DExchangeServe_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I tried to order a text-column only by parts of the entries. Therefore I us= ed regexp_matches(), but unfortunately I am loosing rows. SELECT regexp_matches('abc','[0-9]+'), regexp_matches('123','[0-9]+'); Does not return "{null}, {123}" but no result at all. Is this behavior expected? How can I work around? I am running postgres 8.4 Andreas ___________________________________________________________________________ SCANLAB AG Dr. Andreas Simon Gaab Entwicklung * R & D Siemensstr. 2a * 82178 Puchheim * Germany Tel. +49 (89) 800 746-513 * Fax +49 (89) 800 746-199 mailto:a.gaab@scanlab.de * www.scanlab.de Amtsgericht M=FCnchen: HRB 124707 * USt-IdNr.: DE 129 456 351 Vorstand: Georg Hofner (Sprecher), Christian Huttenloher, Norbert Petschik Aufsichtsrat (Vorsitz): Dr. Hans J. Langer ___________________________________________________________________________ --_000_48DA836F3865C54B8FBF424A3B775AF6671A68395DExchangeServe_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,<= /p>

 

 

SELECT regexp_matches('abc','[0-9]+'),=A0 regexp_matc= hes('123','[0-9]+');

<= o:p> 

Does not return &#= 8220;{null}, {123}” but no result at all.

 

Is this behavior expected? How can I work around?<= /p>

 

I am running postgres 8.4

 

 

Andreas

 

 

_________________________________________= __________________________________

 

SCANLAB AG=

Dr. Andreas&= nbsp;Simon Gaab

Entwicklung • R & D

 

Siemen= sstr. 2a • 82178 Puchheim • Germany=

Tel. +49&nbs= p;(89) 800 746-513 • Fax +49 (89) 800 7= 46-199

mailto:a.gaab@scanlab.de &#= 8226; www.scanlab.de

 

Amtsgeric= ht M=FCnchen: HRB 124707 • USt-IdNr.: DE 129 456&= nbsp;351

Vorstand: Georg Hofner (Sprecher), Christian Hutten= loher, Norbert Petschik

Aufsichtsrat (Vorsitz): Dr. Hans&nbs= p;J. Langer

__________________________________________________________= _________________

 

= --_000_48DA836F3865C54B8FBF424A3B775AF6671A68395DExchangeServe_--