Hi Rudy! On 18 Jan 05 at 14:30, "Rudy" (Rudy Lippan) wrote:
Rudy> Do a recursive traversial of the array and turn it into a string Rudy> with elements surrounded with '"'s and separated by ','s, with Rudy> dementions delimited by '{}' pairs and separated by ','s. And of Rudy> course, you have to escape " that are already in the string and then Rudy> do a final pass with standard postgres string quoting -- but you can Rudy> let the bind_param() call do this last pass. Thank you, that worked. The only thing troubles me a bit is that you said it is a hack. So then, what whould you recommend as a non-hack (kind of a 'best practice') method here? If I understand correctly, after you release the new version, bind_param(":array_column") will be the preferred way to bind arrays, but what is it for now? -- Sincerely, Dmitry Karasik