You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Rainer Döbele (JIRA)" <em...@incubator.apache.org> on 2009/07/02 20:51:47 UTC
[jira] Updated: (EMPIREDB-40) Postgresql cast problem
[ https://issues.apache.org/jira/browse/EMPIREDB-40?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele updated EMPIREDB-40:
----------------------------------
Description:
Solution submitted by Frank Lupo:
public String getConvertPhrase(DataType destType, DataType srcType, Object format)
{
switch(destType)
{
-> case BOOL: return "CAST(? AS BOOL)";
-> case INTEGER: return "CAST(? AS INTEGER)";
case DECIMAL: return "CAST(? AS DECIMAL)";
case DOUBLE: return "CAST(? AS DECIMAL)";
case DATE: return "CAST(? AS DATE)";
-> case DATETIME: return "CAST(? AS TIMESTAMP)";
was:
public String getConvertPhrase(DataType destType, DataType srcType, Object format)
{
switch(destType)
{
-> case BOOL: return "CAST(? AS BOOL)";
-> case INTEGER: return "CAST(? AS INTEGER)";
case DECIMAL: return "CAST(? AS DECIMAL)";
case DOUBLE: return "CAST(? AS DECIMAL)";
case DATE: return "CAST(? AS DATE)";
-> case DATETIME: return "CAST(? AS TIMESTAMP)";
> Postgresql cast problem
> -----------------------
>
> Key: EMPIREDB-40
> URL: https://issues.apache.org/jira/browse/EMPIREDB-40
> Project: Empire-DB
> Issue Type: Bug
> Affects Versions: empire-db-2.0.5-incubating
> Reporter: Rainer Döbele
> Fix For: empire-db-2.0.5-incubating
>
>
> Solution submitted by Frank Lupo:
> public String getConvertPhrase(DataType destType, DataType srcType, Object format)
> {
> switch(destType)
> {
> -> case BOOL: return "CAST(? AS BOOL)";
> -> case INTEGER: return "CAST(? AS INTEGER)";
> case DECIMAL: return "CAST(? AS DECIMAL)";
> case DOUBLE: return "CAST(? AS DECIMAL)";
> case DATE: return "CAST(? AS DATE)";
> -> case DATETIME: return "CAST(? AS TIMESTAMP)";
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.