Re: CVS to In_list without dynamic SQL, how?

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(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 19:51:58
Message-ID: CACpWLjNeNCT0v1TY4gSD2kG_aS7vUN2jFmx2uKB=WgfKxi3Obw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Got it David, thanks!

On Wed, Dec 9, 2015 at 4:51 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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

Browse pgsql-sql by date

  From Date Subject
Next Message Corey Huinker 2015-12-14 20:40:41 Re: regexp_replace question/suggestions needed
Previous Message David G. Johnston 2015-12-10 00:51:03 Re: CVS to In_list without dynamic SQL, how?