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