Re: Column is of type date but expression is of type text - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Column is of type date but expression is of type text
Date
Msg-id 26200.1266776271@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column is of type date but expression is of type text  (list_usr@spacebox.net)
Responses Re: Column is of type date but expression is of type text  (list_usr@spacebox.net)
List pgsql-jdbc
list_usr@spacebox.net writes:
> I think the issue was the ordering of the parameters - after your
> initial answer to my question I updated the stored procedure so the
> ordering of the parameters matched the order that they appeared in the
> insert statement.  I recreated the stored procedure and continued to
> encounter the problem which led me to believe that wasn't the issue.

Note that two functions with the same names and differently ordered
parameter lists are different objects to Postgres.  I think maybe you
forgot to drop the first version and it was still getting invoked.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: list_usr@spacebox.net
Date:
Subject: Re: Column is of type date but expression is of type text
Next
From: list_usr@spacebox.net
Date:
Subject: Re: Column is of type date but expression is of type text