BUG #8613: getting null when null is concatenated with string - Mailing list pgsql-bugs

From rajasekhar5c1@gmail.com
Subject BUG #8613: getting null when null is concatenated with string
Date
Msg-id E1VjlAC-0001mF-6D@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8613: getting null when null is concatenated with string  (Kevin Grittner <kgrittn@ymail.com>)
Re: BUG #8613: getting null when null is concatenated with string  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8613
Logged by:          rajasekhar5c1
Email address:      rajasekhar5c1@gmail.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?

pgsql-bugs by date:

Previous
From: shivshi@cisco.com
Date:
Subject: BUG #8609: Regression tests fail with Postgresql crashing frequently.
Next
From: alexsav23@gmail.com
Date:
Subject: BUG #8608: ECPG: sizeof() in EXEC SQL DECLARE SECTION