PL argument max size, and doubt - Mailing list pgsql-sql

From Martin Marques
Subject PL argument max size, and doubt
Date
Msg-id 4744313C.40107@marquesminen.com.ar
Whole thread Raw
Responses Re: PL argument max size, and doubt
List pgsql-sql
I was doing some tests to see if I could find a max size for an argument
of type TEXT in a PL/PgSQL function (BTW, which it that limit if it
exists?).

So I made the function to test:

CREATE OR REPLACE FUNCTION datoGrande(TEXT) RETURNS BOOLEAN AS $body$
BEGIN
EXECUTE $ins1$
INSERT INTO funcdatogrande VALUES (default,$ins1$ ||     quote_literal($1) || $ins2$)$ins2$;
IF FOUND THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
$body$ LANGUAGE 'plpgsql';


What bothers me is that the INSERT passes ok (the data is inserted) but
the function is returning false on any all to it. I hope not to have a
conceptual problem.


pgsql-sql by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: dynmic column names inside trigger?
Next
From: "Rodrigo De León"
Date:
Subject: Re: PL argument max size, and doubt