Jeff Ross <jross@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
