On 11/19/12 12:58, Tom Lane wrote:
Jeff Ross 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
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Jeff Ross
> Sent: Monday, November 19, 2012 2:49 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Split_part on a CR
>
> Hi,
>
Jeff,
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?
0x0a is actually a new line. This works for me:
select split_part(text_column, E'\n', 1) from table;
--
GC
--
Sent via pgsql-general mail
Jeff Ross 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).
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
