Date: Fri, 14 Aug 2020 12:17:44 -0700 (MST)
From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Message-ID: <1597432664458-0.post@n3.nabble.com>
In-Reply-To: <654057.1597431203@sss.pgh.pa.us>
References: <cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
 <20190204010709.GC1881@paquier.xyz> <1597265258319-0.post@n3.nabble.com>
 <323345.1597270142@sss.pgh.pa.us> <1597410304614-0.post@n3.nabble.com>
 <572934.1597413823@sss.pgh.pa.us> <1597422849057-0.post@n3.nabble.com>
 <650987.1597427089@sss.pgh.pa.us> <1597430001991-0.post@n3.nabble.com>
 <654057.1597431203@sss.pgh.pa.us>
Subject: Re: Server goes to Recovery Mode when run a SQL
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Well, I didn=C2=B4t know where was the problem exactly, then ...
The entire script to see that problem is=20

create domain public.i32 as integer;

CREATE FUNCTION public.fntextonumero(ftext text, finteger public.i32)
RETURNS boolean
    LANGUAGE sql STABLE
    AS $$
  SELECT ftext =3D finteger::text;
$$;
CREATE FUNCTION public.fntextonumero(finteger public.i32, ftext text)
RETURNS boolean
    LANGUAGE sql STABLE
    AS $$
  SELECT ftext =3D finteger::text;
$$;

CREATE OPERATOR public.=3D (
    FUNCTION =3D public.fntextonumero,
    LEFTARG =3D text,
    RIGHTARG =3D public.i32
);
CREATE OPERATOR public.=3D (
    FUNCTION =3D public.fntextonumero,
    LEFTARG =3D public.i32,
    RIGHTARG =3D text
);

Then that script I=C2=B4ve sent you this morning.
This way I think you can get the problem. Is this a Postgres problem ? Well=
,
I created these operators because Firebird accepts comparisons between
numeric and text values, and as we converted from that ... I found a way to
continue comparing them. The problem ocurred now because the IN operator.=
=20


--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.h=
tml