I dont mind if the commas are at the beginning and end, im more concerned about "three,four" staying in one row because its surrounded by quotes. -Nick On Sep 10, 6:03 pm, alvhe...@xxxxxxxxxxxxxxxxx (Alvaro Herrera) wrote: > Excerpts from Nick's message of vie sep 10 20:36:24 -0400 2010: > > > Yes, that gets down to the root of my question... what is the > > expression that would properly split the values? -Nick > > The only idea that comes to mind right now is to remove them before > processing the rest of the string, and put them back to the first and > last element if they were removed. > > -- > Álvaro Herrera <alvhe...@xxxxxxxxxxxxxxxxx> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > > -- > Sent via pgsql-general mailing list (pgsql-gene...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general