Re: Column is of type date but expression is of type text

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