From: | Ben Madin <ben(at)ausvet(dot)com(dot)au> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: invalid input syntax for integer: "" - more confusion |
Date: | 2013-02-06 04:54:23 |
Message-ID: | C847C040-E770-40E6-9D34-126CD683255B@ausvet.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-02-06 04:57:18 | Re: ERROR: invalid input syntax for integer: "" |
Previous Message | Adrian Klaver | 2013-02-06 04:52:50 | Re: ERROR: invalid input syntax for integer: "" |