What is String_To_Array function in PostgreSQL?

 Posted by Niladri.Biswas on 4/29/2013 | Category: PostgreSQL Interview questions | Views: 3272 | Points: 40
Answer:

This functions splits a string to an array provided the delimeter is supplied. It returns an array.

Syntax: String_To_Array(String,delimeter)

e.g.

Select String_To_Array('Hello World Today I am learning String_To_Array It is very cool',' ')

/* Result */
string_to_array
----------------
{Hello,World,Today,I,am,learning,String_To_Array,It,is,very,cool}


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response