Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 18 Feb 2010 17:11:55 -0500 (EST)
- Message-id: <alpine.BSO.2.00.1002181708530.7153@leary.csoft.net> <text/plain>
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:
FuncTest.java
Description: Text document
- Follow-Ups:
- Re: Column is of type date but expression is of type text
- From: list_usr
- Re: Column is of type date but expression is of type text
- References:
- Column is of type date but expression is of type text
- From: list_usr
- Re: Column is of type date but expression is of type text
- From: Kris Jurka
- Re: Column is of type date but expression is of type text
- From: list_usr
- Column is of type date but expression is of type text
- Prev by Date: Re: Column is of type date but expression is of type text
- Next by Date: auto savepoint in a transaction
- Previous by thread: Re: Column is of type date but expression is of type text
- Next by thread: Re: Column is of type date but expression is of type text
- Indexes: