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

G'day Adrian,

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

>
> 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(at)ausvet(dot)com(dot)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.