Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifAtB-0003Si-WC for pgsql-docs@arkaria.postgresql.org; Wed, 11 Dec 2019 22:55:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ifAt9-0004pe-Fc for pgsql-docs@arkaria.postgresql.org; Wed, 11 Dec 2019 22:55:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifAt9-0004pX-5P for pgsql-docs@lists.postgresql.org; Wed, 11 Dec 2019 22:55:23 +0000 Received: from mail-qv1-xf36.google.com ([2607:f8b0:4864:20::f36]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ifAt5-0007Fk-Vo for pgsql-docs@lists.postgresql.org; Wed, 11 Dec 2019 22:55:22 +0000 Received: by mail-qv1-xf36.google.com with SMTP id n8so152119qvg.11 for ; Wed, 11 Dec 2019 14:55:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=/MpflD9RAYcAi/E/ConhRxq9q11t/+S+vkcuRdOkkhM=; b=fyZiKO4xCI8Fd8rBs6lKcxLygJpDxK5oeAWiyZ7hpjgyzbCtVvALz7cRjIGZ169ItZ OQuX+Djoa1tfnxTi3e1QktBMOJcuOlUAclB1zXy04+oBxT3dDv+mwGzvjJHu2h4yqqin WEW14H9FKgOwlK+I7pb0nrNEW7Yhw+B9I+QRwg6Sgfm4rcH3toY9iMZT0ztxqNoooaPT hfYVO0BTKWgl2XSKI/cNEL6V56ze5qFa1gf1hqkJl424HcbglOtLCI9glYIBm02tW8Qj cbQGwqLPyiGJPGfj1N9u+/6sIsKZT2h0tWE6RxAeqRfhSjgJebF2WKkhz6gU+0iZEBPW ZP/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=/MpflD9RAYcAi/E/ConhRxq9q11t/+S+vkcuRdOkkhM=; b=c0T8KBXv4T3Kcik9CdwjTrmk4QSa7dt+ilBszlSpBam1gZ9zx+Z2YGKzFT2jrqo8B1 dbKTIN+n2eC0HqATtF9nBHzGlgxxZID/G/7BaxcP5q9H29Isg/OeQdolsRDyR89sRpSd pCQOCDvbTOgOctiaKg5q0ZB9Oyz99uAQvKt6mzsPSS3Y4Li2O+NsptRUAAVvaQMfTaza NJDuw/11Rt8F2DsUgkshvTDCSAMy3HOFhDK6g+mJ0otVghabgvIIvTpe98skW6izggE0 4iwOmUeYM/LID/Bc+fPLo24vtAvN6hRFQaNK9wKkMCGoirHXrkOwQyb3RCHMJpjKR9xU kQaA== X-Gm-Message-State: APjAAAUZ5gte4cM/Fd0W5BC/inIyPoqRG7JJ8ojBGzl+KoDW3m7GwBYK zuckgVGJbdSwq5RCqIOjOVb6eEFLh0oeafsgfyY= X-Google-Smtp-Source: APXvYqz/erWDJmCSnswTYtezhZIPxVVM5FkPFu53g2hi9ClloYUPYvqTGK03hIn6uPzRUse9mu1w1XHxEoB+UMkXP5g= X-Received: by 2002:a05:6214:11ac:: with SMTP id u12mr5539483qvv.85.1576104917838; Wed, 11 Dec 2019 14:55:17 -0800 (PST) MIME-Version: 1.0 References: <157609824566.18137.1801564485753283869@wrigleys.postgresql.org> In-Reply-To: <157609824566.18137.1801564485753283869@wrigleys.postgresql.org> From: "David G. Johnston" Date: Wed, 11 Dec 2019 15:55:01 -0700 Message-ID: Subject: Re: Example for unnest(anyarray, anyarray) fails To: Guyren Howe , pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000c1af2905997585d7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000c1af2905997585d7 Content-Type: text/plain; charset="UTF-8" On Wed, Dec 11, 2019 at 3:21 PM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/functions-array.html > Description: > > [...] > 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. > As your query doesn't place the unnest function in the FROM clause as the documentation says is required it is to be expected that your query fails. The subsequent part of that sentence links you over to the section of the documentation that provides a full example. The one in the table is intended as a quick-reference. David J. --000000000000c1af2905997585d7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Dec 11, 2019 at 3:21 PM PG Doc comments form <<= a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org> wro= te:
The following documentation comment has been lo= gged on the website:

Page: https://www.postgresql.org/docs/9.6/fu= nctions-array.html
Description:

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

As your query= doesn't place the unnest function in the FROM clause as the documentat= ion says is required it is to be expected that your query fails.=C2=A0 The = subsequent part of that sentence links you over to the section of the docum= entation that provides a full example.=C2=A0 The one in the table is intend= ed as a quick-reference.

David J.
=
--000000000000c1af2905997585d7--