By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Function array_to_string(text[], text) does not exist ???

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

P: n/a
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:mi**@fuhr.org]
Envoyé*: mardi 5 octobre 2004 15:06
À*: Johann Robette
Cc*: pg***********@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/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.