Re: CVS to In_list without dynamic SQL, how?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Michael Moore <michaeljmoore(at)gmail(dot)com>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: CVS to In_list without dynamic SQL, how?
Date: 2015-12-10 00:51:03
Message-ID: CAKFQuwYuzjrwWFJTTM8jsO+dw0gmt0Wbdui-ryUK2o=E+BPhFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday, December 9, 2015, Michael Moore <michaeljmoore(at)gmail(dot)com>
wrote:

> Very nice!
> In my case the value being compared is numeric. I tried:
> SELECT to_char( 1 , '999') = ANY( string_to_array('1,2,3,4,5', ','));
> but the result is FALSE
>
>
Make the array integer to match.

string_to_array(...)::integer[]

David J.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Moore 2015-12-10 19:51:58 Re: CVS to In_list without dynamic SQL, how?
Previous Message Michael Moore 2015-12-09 23:04:08 Re: Regexp_replace question/assistance needed