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.