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

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

list_usr(at)spacebox(dot)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