> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Jeff Ross
> Sent: Monday, November 19, 2012 2:49 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Split_part on a CR
>
> Hi,
>
> I'm having a hard time figuring out how to use split_part with a carriage
> return (hex 0a) as the delimiter.
>
> Would someone please offer me a clue?
>
> Thanks!
>
> Jeff Ross
>
SELECT split_part(E'a\nb\nc', E'\n', 2) -- == 'b'
David J.