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 ? : http://www.po

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

[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: http://w

[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: http://postgresql.1045698.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387932p3

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

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}

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