Re: Bug when performing command SELECT without cast

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.