From: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
---|---|
To: | Chuck Roberts <croberts(at)gilsongraphics(dot)com>, PSql novice list <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Trouble with IN operator |
Date: | 2017-02-03 18:14:47 |
Message-ID: | MWHPR11MB2032F5F82494D5409194A9F1AB4F0@MWHPR11MB2032.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Empty String or Null?
Try: trim(Coalesce(tbl.costcenter,’’)) IN …
Chris Campbell | Software Architect
C A S C A D E D A T A S O L U T I O N S
(800) 280-2090
www.cascadeds.com<http://www.cascadeds.com/>
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Chuck Roberts
Sent: Friday, February 3, 2017 10:08 AM
To: PSql novice list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [NOVICE] Trouble with IN operator
This is a vendor's database and we don't have control over it, nor do we have direct access to the Postgresql table layouts. We are given a spreadsheet to show us what the data types are.
As for the data, sometimes tbl.costcenter can be blank on some records. Surely that wouldn't interfere with the IN operator?
Chuck
Thanks!
Chuck Roberts
Gilson Graphics | Composition Dept.
p:616-459-4539 x 1228
On Fri, Feb 3, 2017 at 12:37 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
On Fri, Feb 3, 2017 at 10:12 AM, Chuck Roberts <croberts(at)gilsongraphics(dot)com<mailto:croberts(at)gilsongraphics(dot)com>> wrote:
AND (TRIM(tbl.costcenter) IN ('540'))
Can anyone shed some light on this for me?
It works...
WITH tbl (id, costcenter) AS ( VALUES (1, '500'), (2, '550') )
SELECT *
FROM tbl
WHERE (trim(tbl.costcenter) IN ('550'));
So the problem resides in something you haven't show us - namely data.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Chuck Roberts | 2017-02-03 18:29:27 | Re: Trouble with IN operator |
Previous Message | Chuck Roberts | 2017-02-03 18:08:19 | Re: Trouble with IN operator |