Re: Split_part on a CR

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