You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by Frank Lupo <fr...@email.it> on 2009/07/02 17:47:10 UTC
Cast Postgresql Problem
=============================================================
CURRENT
=============================================================
public String getConvertPhrase(DataType destType, DataType srcType, Object format)
{
switch(destType)
{
case BOOL: return "CAST(? AS UNSIGNED)";
case INTEGER: return "CAST(? AS SIGNED)";
case DECIMAL: return "CAST(? AS DECIMAL)";
case DOUBLE: return "CAST(? AS DECIMAL)";
case DATE: return "CAST(? AS DATE)";
case DATETIME: return "CAST(? AS DATETIME)";
=============================================================
FIX
=============================================================
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)";
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
250 Biglietti da Visita gratuiti + 1 elegante Porta biglietti metallico! Spese di spedizione escluse. Offerta limitata, fai in fretta!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8958&d=2-7
Re: Cast Postgresql Problem
Posted by Francis De Brabandere <fr...@gmail.com>.
Ok, I submitted the changes, thanks for reporting!
On Thu, Jul 2, 2009 at 5:53 PM, Francis De
Brabandere<fr...@gmail.com> wrote:
> I'll take care of this this evening, could you please make jira issues
> in the future so that we kan keep track of these bugs?
>
> https://issues.apache.org/jira/browse/EMPIREDB
>
>
> 2009/7/2 Frank Lupo <fr...@email.it>:
>> =============================================================
>> CURRENT
>> =============================================================
>> public String getConvertPhrase(DataType destType, DataType srcType, Object
>> format)
>> {
>> switch(destType)
>> {
>> case BOOL: return "CAST(? AS UNSIGNED)";
>> case INTEGER: return "CAST(? AS SIGNED)";
>> case DECIMAL: return "CAST(? AS DECIMAL)";
>> case DOUBLE: return "CAST(? AS DECIMAL)";
>> case DATE: return "CAST(? AS DATE)";
>> case DATETIME: return "CAST(? AS DATETIME)";
>>
>> =============================================================
>> FIX
>> =============================================================
>>
>> 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)";
>>
>>
>>
>>
>> --
>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>
>> Sponsor:
>> 250 Biglietti da Visita gratuiti + 1 elegante Porta biglietti metallico!
>> Spese di spedizione escluse. Offerta limitata, fai in fretta!
>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8958&d=2-7
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: Cast Postgresql Problem
Posted by Francis De Brabandere <fr...@gmail.com>.
I'll take care of this this evening, could you please make jira issues
in the future so that we kan keep track of these bugs?
https://issues.apache.org/jira/browse/EMPIREDB
2009/7/2 Frank Lupo <fr...@email.it>:
> =============================================================
> CURRENT
> =============================================================
> public String getConvertPhrase(DataType destType, DataType srcType, Object
> format)
> {
> switch(destType)
> {
> case BOOL: return "CAST(? AS UNSIGNED)";
> case INTEGER: return "CAST(? AS SIGNED)";
> case DECIMAL: return "CAST(? AS DECIMAL)";
> case DOUBLE: return "CAST(? AS DECIMAL)";
> case DATE: return "CAST(? AS DATE)";
> case DATETIME: return "CAST(? AS DATETIME)";
>
> =============================================================
> FIX
> =============================================================
>
> 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)";
>
>
>
>
> --
> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
> autenticato? GRATIS solo con Email.it http://www.email.it/f
>
> Sponsor:
> 250 Biglietti da Visita gratuiti + 1 elegante Porta biglietti metallico!
> Spese di spedizione escluse. Offerta limitata, fai in fretta!
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8958&d=2-7
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.