Conversion of array -> varchar

Help
2013-08-15
2014-01-19
  • Brian Krahmer
    Brian Krahmer
    2013-08-15

    I want to be able to use the contents of an array in a like clause, but can't figure out how.  Is there a cast function or similar that can give me a textual representation of an array field?

    thanks,
    brian

     
  • Fred Toussi
    Fred Toussi
    2013-08-15

    Your question is not clear. Please provide an example together with the definition of the column that is an array..

     
  • Brian Krahmer
    Brian Krahmer
    2013-08-22

    My bad.  I see now that I can treat the field essentially as a varchar field and use like against it, or use something like POSITION_ARRAY to look for elements

    brian

     
  • Fred Toussi
    Fred Toussi
    2013-08-23

    Look up the UNNEST keyword for accessing the elements as a table.