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

From Jeff Ross
Subject Re: Split_part on a CR
Date
Msg-id 50AA9FED.50003@wykids.org
Whole thread Raw
In response to Re: Split_part on a CR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 11/19/12 12:58, Tom Lane wrote:
> 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
>
>

Arrrggghhh!  I *knew* it was going to be something simple.

Thanks again all,

Jeff


pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Split_part on a CR
Next
From: Thomas Hill
Date:
Subject: Re: Experiences with pl/Java