Home > mailing lists

replace_matches does not return {null} - Mailing list pgsql-sql

From	Andreas Gaab
Subject	replace_matches does not return {null}
Date	February 22, 2011 07:25:16
Msg-id	48DA836F3865C54B8FBF424A3B775AF6671A68395D@Exchange-Server Whole thread Raw
Responses	Re: replace_matches does not return {null}
List	pgsql-sql

Hi,

I tried to order a text-column only by parts of the entries. Therefore I used 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

Amtsgericht München: HRB 124707 • USt-IdNr.: DE 129 456 351

Vorstand: Georg Hofner (Sprecher), Christian Huttenloher, Norbert Petschik

Aufsichtsrat (Vorsitz): Dr. Hans J. Langer

___________________________________________________________________________

From: "Gnanakumar"
Date: 21 February 2011, 07:54:19
Subject: Re: Is it possible to get DISTINCT rows from RETURNING clause?

From: Tom Lane
Date: 22 February 2011, 12:39:26
Subject: Re: replace_matches does not return {null}