Re: Split_part on a CR

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Ross <jross(at)wykids(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Split_part on a CR
Date: 2012-11-19 19:59:19
Message-ID: 11344.1353355159@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gary Chambers 2012-11-19 20:00:16 Re: Split_part on a CR
Previous Message Thomas Hill 2012-11-19 19:55:25 Re: Experiences with pl/Java