Postgres Pro
Downloads
Home   >   mailing lists

Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" - Mailing list pgsql-general

From David G. Johnston
Subject Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"
Date
Msg-id CAKFQuwZ_9=MteMfps3ZL2P3KqTy_SnpQedDKFWeU_E5EuXCd1w@mail.gmail.com
Whole thread Raw
In response to select (17, 42)::s.t2 into... fails with "invalid input syntax"  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-general
Tree view
On Wed, Mar 8, 2023 at 5:41 PM Bryn Llewellyn <bryn@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.

pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: select (17, 42)::s.t2 into... fails with "invalid input syntax"
Next
From: Tom Lane
Date:
Subject: Re: select (17, 42)::s.t2 into... fails with "invalid input syntax"