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/