From: | natan(at)logicasistemas(dot)com(dot)br |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11401: When I comparison geting of field returns false, but when I do directly with result returns true |
Date: | 2014-09-11 21:27:06 |
Message-ID: | 20140911212706.2484.18059@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: 11401
Logged by: Natan Medeiros
Email address: natan(at)logicasistemas(dot)com(dot)br
PostgreSQL version: 9.1.14
Operating system: Debian
Description:
Hi everyone,
I'm trying to do a query and stops in source below:
btrim = clean spaces
upper = a -> A
pcc.mac returns "" (null)
pcc.username returns "SIMONE.GISELIA"
btrim(upper(pcc.mac::character varying::text)) <>
btrim(upper(pcc.username::text))
if I put the code above, the postgres understand as false, but if I put the
code below returns true, why?
SELECT CASE WHEN "" <> "SIMONE.GISELIA" THEN true ELSE false end
Both fields returns different text and the result is false and shouldn't.
I'm stuck on that and don't know what do.
I need to compare this options, if don't, the source not work.
If anyone could help me I will be glad for that.
From | Date | Subject | |
---|---|---|---|
Next Message | marko | 2014-09-11 21:58:05 | BUG #11402: Prepared statement cache invalidation and unknown types |
Previous Message | kkaminski | 2014-09-11 20:23:35 | BUG #11399: CreateUser error when upgrading |