enterprisedb - postgres treat null as empty string when concatenated with string

When I fire below query on one of our servers select null || 'query' ,'|',versionthe result is null nothing is displayedwhen i fire the same query on another server which has same version of postgresql serverI am getting result as querypostgres version on both servers are EnterpriseDB on i686-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 32-bitEnterpriseDB on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bitWhy this different behavior?...Read more

enterprisedb - Problem with returning records

Here is the problem with Postgresql that I am facing for last few days:Usingselect usage_rep_sp.get_result('2009-01-01','2009-12-01')full_name from dual;The package below supposes to return a number of records((at least 5 different names) However it returns just one.From iReports it gives me the error message:Caused by: org.postgresql.util.PSQLException: ERROR: cursor "()" does not exist ;Could you help me with these problems?CREATE OR REPLACE PACKAGE usage_rep_spIStype usage_type is record (full_name varchar2(50));-- type srr_rec is ref c...Read more