From: | rajasekhar5c1(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8613: getting null when null is concatenated with string |
Date: | 2013-11-22 07:28:28 |
Message-ID: | E1VjlAC-0001mF-6D@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 8613
Logged by: rajasekhar5c1
Email address: rajasekhar5c1(at)gmail(dot)com
PostgreSQL version: 9.2.1
Operating system: linux
Description:
when i fire below query on one of our servers
select null || 'query' ,'|'
the result is null nothing is displayed
when i fire the same query on another server which has same version of
postgresql server
i am getting result as
query
postgres version on both servers are
1) EnterpriseDB 9.2.1.3 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 32-bit 2) EnterpriseDB 9.2.1.3 on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat
4.1.2-52), 64-bit
why this different behavior?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2013-11-22 13:22:17 | Re: fe-secure.c and SSL/TLS |
Previous Message | Shiv Shivaraju Gowda (shivshi) | 2013-11-22 01:59:58 | PostgreSQL 6.2.5 Visual Studio Build does not pass the regression tests. |