Re: Split_part on a CR - Mailing list pgsql-general

From Tom Lane
Subject Re: Split_part on a CR
Date
Msg-id 11344.1353355159@sss.pgh.pa.us
Whole thread Raw
In response to Split_part on a CR  (Jeff Ross <jross@wykids.org>)
Responses Re: Split_part on a CR
List pgsql-general
Jeff Ross <jross@wykids.org> writes:
> Hi,
> I'm having a hard time figuring out how to use split_part with a
> carriage return (hex 0a) as the delimiter.

Um, 0x0a is line feed last I checked.  But you should be able to write
the literal as E'\r' (if you wanted CR) or E'\n' (if you wanted LF).

            regards, tom lane


pgsql-general by date:

Previous
From: Thomas Hill
Date:
Subject: Re: Experiences with pl/Java
Next
From: Gary Chambers
Date:
Subject: Re: Split_part on a CR