| From: | Desenvolvimento <ernane(at)planit(dot)com(dot)br> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Bug when performing command SELECT without cast |
| Date: | 2014-06-24 14:22:08 |
| Message-ID: | 53A98990.1070605@planit.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
ON 24/06/2014 10:59 AM, Adrian Klaver wrote:
> 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;"
>
>
>
I'm using Microsoft Visual FoxPro 9.0 SP2 with driver "PostgreSQL UNICODE".
When I execute "SELECT 1058;" my return is "1058" type numeric.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-06-24 14:33:02 | Re: Bug when performing command SELECT without cast |
| Previous Message | Adrian Klaver | 2014-06-24 13:59:51 | Re: Bug when performing command SELECT without cast |