| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Chuck Roberts <croberts(at)gilsongraphics(dot)com> |
| Cc: | PSql novice list <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Trouble with IN operator |
| Date: | 2017-02-03 18:52:11 |
| Message-ID: | CAKFQuwZi0QiPVhzTf1rMCdDLAoBf3b7uP-o+aAhG7eT1RhiNdg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Friday, February 3, 2017, Chuck Roberts <croberts(at)gilsongraphics(dot)com>
wrote:
> . And now it's critical. I'm using the psql tool
> in a Windows 7 command window, version is 7.4.6.
>
Version 7.4 of what?
>
> I wonder if I'm missing something basic, which is not even in the manuals
> I've beeI've already googled to find some help but have found no info or
> examples on using IN with an array of strings. So here's what I'm trying to
> do:
>
> AND (TRIM(tbl.costcenter) IN ('540'))
>
I don't see an array here...
>
> This results on no error, but also no records. When I take this simple
> clause out, I get records.
>
If you show us even one of those example records you will get much better
help.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cat | 2017-02-04 04:23:12 | Re: Trouble with IN operator |
| Previous Message | Chuck Roberts | 2017-02-03 18:48:49 | Re: Trouble with IN operator |