Thread: Function array_to_string(text[], text) does not exist ???
Hi,
I’m trying to call the array_to_string function like this :
SELECT array_to_string(array[1, 2, 3], '~^~') à it comes directly from the doc.
I get this error msg :
ERROR: parser: parse error at or near "[" at character 24
So I tried this way
SELECT array_to_string('{1, 2, 3}', '~^~')
I get this error msg :
ERROR: Function array_to_string("unknown", "unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
So I tried to cast it
SELECT array_to_string(CAST('{1, 2, 3}' AS _int8), CAST('~^~' AS text))
I get this error msg :
ERROR: Function array_to_string(bigint[], text) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
Any help would be greatly appreciated…
Thanks
On Tue, Oct 05, 2004 at 12:07:11PM +0200, Johann Robette wrote: > I'm trying to call the array_to_string function like this : > SELECT array_to_string(array[1, 2, 3], '~^~') --> it comes > directly from the doc. > I get this error msg : > ERROR: parser: parse error at or near "[" at character 24 What version of PostgreSQL are you running? According to the Release Notes, array constructors and array_to_string() were added in 7.4. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
Ok, that must be it. In fact I was originally using 7.3 but I thought that we've upgraded to 7.4 but apparently note. What I would do is upgrade it and it should work... Thanls -----Message d'origine----- De : Michael Fuhr [mailto:mike@fuhr.org] Envoyé : mardi 5 octobre 2004 15:06 À : Johann Robette Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Function array_to_string(text[], text) does not exist ??? On Tue, Oct 05, 2004 at 12:07:11PM +0200, Johann Robette wrote: > I'm trying to call the array_to_string function like this : > SELECT array_to_string(array[1, 2, 3], '~^~') --> it comes > directly from the doc. > I get this error msg : > ERROR: parser: parse error at or near "[" at character 24 What version of PostgreSQL are you running? According to the Release Notes, array constructors and array_to_string() were added in 7.4. -- Michael Fuhr http://www.fuhr.org/~mfuhr/