On 11/19/12 12:58, Tom Lane wrote:
Jeff Ross <jr...@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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to