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

[David G. Johnston]

On Wed, Mar 8, 2023 at 5:41 PM Bryn Llewellyn <b...@yugabyte.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.