Re: Bug when performing command SELECT without cast

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