Input data for column is not compatible with data type

On Wed, Feb 10, 2016 at 12:56 PM, drum.lucas@gmail.com <drum.lucas@gmail.com

wrote:

Hi all

I'm having this error message:

Input data for column `%1$s` is not compatible with data type

But I was unable to find the table which is having this issue....

Would be possible someone help me with that?
Thanks

Complete error link:
https://bitbucket.org/snippets/lucaspossamai/7r9yX

Query link:
https://bitbucket.org/snippets/lucaspossamai/rbpk4/edit/

​For those who come later please, if at all possible, write self-contained
emails.

David J.​

Actually I do know which table is...

it seems to be ja_notes.

But I can't see any difference

Lucas Possamai

- kinghost.co.nz
<http://forum.kinghost.co.nz/memberlist.php?mode=viewprofile&amp;u=2&amp;sid=e999f8370385657a65d41d5ff60b0b38&gt;
- DigitalOcean <https://m.do.co/c/a0d31c597a03&gt;

On 11 February 2016 at 09:11, David G. Johnston <david.g.johnston@gmail.com>
wrote:

On 02/10/2016 11:56 AM, drum.lucas@gmail.com wrote:

Hi all

I'm having this error message:

Input data for column `%1$s` is not compatible with data type

The above, from looking at the link below, looks like part of the query.

If that is so I am guessing the back ticks are causing the problem.

If not what is the actual error message and what is creating it?

But I was unable to find the table which is having this issue....

Would be possible someone help me with that?
Thanks

Complete error link:
https://bitbucket.org/snippets/lucaspossamai/7r9yX

Query link:
https://bitbucket.org/snippets/lucaspossamai/rbpk4/edit/

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 02/10/2016 12:11 PM, David G. Johnston wrote:

On Wed, Feb 10, 2016 at 12:56 PM, drum.lucas@gmail.com
<mailto:drum.lucas@gmail.com> <drum.lucas@gmail.com
<mailto:drum.lucas@gmail.com>>wrote:

Hi all

I'm having this error message:

Input data for column `%1$s` is not compatible with data type

But I was unable to find the table which is having this issue....

Would be possible someone help me with that?
Thanks

Complete error link:
https://bitbucket.org/snippets/lucaspossamai/7r9yX

Query link:
https://bitbucket.org/snippets/lucaspossamai/rbpk4/edit/

​For those who come later please, if at all possible, write
self-contained emails.

In that vein the second link is non-functional:(

David J.​

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

yep..

thank you for your replly.

The problem is a code problem. Not in the DB.

Thank you.

Lucas Possamai

- kinghost.co.nz
<http://forum.kinghost.co.nz/memberlist.php?mode=viewprofile&amp;u=2&amp;sid=e999f8370385657a65d41d5ff60b0b38&gt;
- DigitalOcean <https://m.do.co/c/a0d31c597a03&gt;

On 11 February 2016 at 10:27, Adrian Klaver <adrian.klaver@aklaver.com>
wrote: