Example for unnest(anyarray, anyarray) fails

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: guyren(at)gmail(dot)com
Subject: Example for unnest(anyarray, anyarray) fails
Date: 2019-12-11 21:04:05
Message-ID: 157609824566.18137.1801564485753283869@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/functions-array.html
Description:

~ $ psql
psql (11.2, server 9.6.14)
Type "help" for help.

ghowe=# select version();
version

---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.14 on x86_64-apple-darwin14.5.0, compiled by Apple LLVM
version 7.0.0 (clang-700.1.76), 64-bit
(1 row)

ghowe=# select unnest(ARRAY[1,2],ARRAY['foo','bar','baz']);
ERROR: function unnest(integer[], text[]) does not exist
LINE 1: select unnest(ARRAY[1,2],ARRAY['foo','bar','baz'])
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2019-12-11 22:55:01 Re: Example for unnest(anyarray, anyarray) fails
Previous Message Devrim Gündüz 2019-12-11 11:53:19 Re: I suggest improving install steps for CentOS 8