Horton

Re: Server goes to Recovery Mode when run a SQL

Marcos Pegoraro <marcos@f10.com.br>

View thread View on postgr.es
From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Date: 2020-08-14T18:56:03Z
Lists: pgsql-general 
And the operator function, just to you know, is only a conversion to text

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

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




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Commits

  1. Be more careful about the shape of hashable subplan clauses.