Re: [SQL] replace_matches does not return {null}

2011-02-22 Thread Tom Lane
Andreas Gaab writes: > 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. Yes, b

[SQL] replace_matches does not return {null}

2011-02-22 Thread Andreas Gaab
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