BUG #8613: getting null when null is concatenated with string

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?

Responses

Browse pgsql-bugs by date

  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.