G'day Adrian, On 2013-02-06, at 12:44 , Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > This one I could see if the split_part yielded an empty string. You are right on this one - the higher level components don't have a split part 2. Thank you. > > What type is locationcode and could you provide an example? Varchar an example would be 6 for level 1 field, and 6.34 for level 2. cheers Ben -- Ben Madin t : +61 8 6102 5535 m : +61 448 887 220 e : ben@xxxxxxxxxxxxx AusVet Animal Health Services P.O. Box 5467 Broome WA 6725 Australia AusVet's website: http://www.ausvet.com.au This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this email are the opinion of the writer only and are not endorsed by AusVet Animal Health Services unless expressly stated otherwise. Although AusVet uses virus scanning software we do not accept liability for viruses or similar in any attachments. Thanks for reading. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
