> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Jeff Ross > Sent: Monday, November 19, 2012 2:49 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
