Split strings into array elements using provided delimiter string_to_array('xx~^~yy~^~zz', '~^~') output: {xx,yy,zz} http://www.postgresql.org/docs/8.3/interactive/functions-array.html ? Martin ______________________________________________ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination or copying hereof is prohibited. This message serves for information purposes only and shall not have any legally binding effect. Given that e-mails can easily be subject to manipulation, we can not accept any liability for the content provided. > Date: Wed, 1 Apr 2009 15:49:42 -0400 > From: justin@xxxxxxxxxxxxxxx > To: robertmhaas@xxxxxxxxx > CC: tgl@xxxxxxxxxxxxx; stark@xxxxxxxxxxxxxxxx; sam@xxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx; pgsql-hackers@xxxxxxxxxxxxxx > Subject: Re: [HACKERS] string_to_array with empty input > > If someone can show me a real world example this logic simplifies the > code and has more uses I'll bite > > > I just presently can't see how this works better. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Rediscover Hotmail®: Get e-mail storage that grows with you. Check it out. |