Function array_to_string(text[], text) does not exist ???
От | Johann Robette |
---|---|
Тема | Function array_to_string(text[], text) does not exist ??? |
Дата | |
Msg-id | 000501c4aac3$180c7230$a5010a0a@Johann обсуждение исходный текст |
Ответы |
Re: Function array_to_string(text[], text) does not exist ???
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: