[SQL] replace_matches does not return {null}

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

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

Andreas Gaab a.g...@scanlab.de 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

[SQL] Re: Retrieve the column values of a record without knowing the names

Thanks Dmitry Grishin. The only problem is that my DBA didn't permit install this command... :( But, I quit this problem... Thanks by attention... -- View this message in context:

[SQL] quotes etc

Hi, I would have thought that there would be a simple built-in function that would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not see anything? I am I wrong? Johnf -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription:

Re: [SQL] quotes etc

On Tue, Feb 22, 2011 at 12:26:41PM -0800, John Fabiani wrote: Hi, I would have thought that there would be a simple built-in function that would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not see anything? I am I wrong? Johnf The manual goes over many

Re: [SQL] quotes etc

On Tuesday, February 22, 2011 12:26:41 pm John Fabiani wrote: Hi, I would have thought that there would be a simple built-in function that would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not see anything? I am I wrong? Johnf Dollar quoting ? :