Re: Split_part on a CR

From: Jeff Ross <jross(at)wykids(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Split_part on a CR
Date: 2012-11-19 21:08:37
Message-ID: 50AA9FED.50003@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/19/12 12:58, Tom Lane wrote:
> Jeff Ross <jross(at)wykids(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hill 2012-11-19 22:56:49 Re: Experiences with pl/Java
Previous Message David Johnston 2012-11-19 20:04:47 Re: Split_part on a CR