Re: Bug when performing command SELECT without cast - Mailing list pgsql-odbc

From Adrian Klaver
Subject Re: Bug when performing command SELECT without cast
Date
Msg-id 53A98457.8050806@aklaver.com
Whole thread Raw
In response to Re: Bug when performing command SELECT without cast  (Desenvolvimento <ernane@planit.com.br>)
Responses Re: Bug when performing command SELECT without cast  (Desenvolvimento <ernane@planit.com.br>)
List pgsql-odbc
On 06/24/2014 04:40 AM, Desenvolvimento wrote:
> I'm working with OS Windows 8.1 Pro 64-bit and my server is:
> Linux - Cent-OS
> PostgreSQL 8.4.21 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
> 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
>
> About the empty space, the correct string is:
> "SELECT '1058';" -- Without space.
>
> If I cast it, the return will be:
> "SELECT '1058'::char(4);"
> Return: "1058"


In what program are you doing the above?

What happens if you do?:

"SELECT 1058;"



--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-odbc by date:

Previous
From: Marco Gaiarin
Date:
Subject: Re: Upgrading by double-clicking the .msi
Next
From: Desenvolvimento
Date:
Subject: Re: Bug when performing command SELECT without cast