Re: ERROR: invalid input syntax for integer: "" - more confusion

G'day Adrian,

On 2013-02-06, at 12:44 , Adrian Klaver <adrian.klaver@gmail.com> 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.

>=20
> 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



--=20

Ben Madin

t : +61 8 6102 5535
m : +61 448 887 220
e : ben@ausvet.com.au

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.