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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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