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