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

From Kris Jurka
Subject Re: Column is of type date but expression is of type text
Date
Msg-id alpine.BSO.2.00.1002181708530.7153@leary.csoft.net
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

On Thu, 18 Feb 2010, list_usr@spacebox.net wrote:

> Here is the stored procedure in question:

The attached testcase works fine for me.  What driver and server versions
do you have?

>
> As an aside, how do most people name their IN parameters so as not to
> have them conflict with actual column names?
>

Some people prefix them with v_ to indicate that they are variables.

Kris Jurka

Attachment

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: Mr Miquel Jordana
Date:
Subject: auto savepoint in a transaction