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

From: Kris Jurka <books(at)ejurka(dot)com>
To: list_usr(at)spacebox(dot)net
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Column is of type date but expression is of type text
Date: 2010-02-18 22:11:55
Message-ID: alpine.BSO.2.00.1002181708530.7153@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 18 Feb 2010, list_usr(at)spacebox(dot)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 Content-Type Size
FuncTest.java text/plain 1.4 KB

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mr Miquel Jordana 2010-02-19 20:03:08 auto savepoint in a transaction
Previous Message list_usr 2010-02-18 21:27:12 Re: Column is of type date but expression is of type text