Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
Date: 2023-03-09 00:50:41
Message-ID: CAKFQuwZ_9=MteMfps3ZL2P3KqTy_SnpQedDKFWeU_E5EuXCd1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 8, 2023 at 5:41 PM Bryn Llewellyn <bryn(at)yugabyte(dot)com> wrote:

>
> select (((17, 42)::s.t2)::text)::s.t2 into r2;
>
> then I'm back to the same 22P02 error:
>
> invalid input syntax for type integer: "(17,42)"
>
>
Single quotes. SELECT '(17,42)'::s.t2;
David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-03-09 02:26:40 Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
Previous Message Bryn Llewellyn 2023-03-09 00:41:39 select (17, 42)::s.t2 into... fails with "invalid input syntax"