Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3F0152E0048
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 21 Nov 2007 09:23:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 09259-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 21 Nov 2007 09:23:10 -0400 (AST)
Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208])
	by postgresql.org (Postfix) with ESMTP id 7C56F2E0038
	for <pgsql-sql@postgresql.org>; Wed, 21 Nov 2007 09:23:10 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by bugs.unl.edu.ar (Postfix) with ESMTP id 4CBF723CB4E
	for <pgsql-sql@postgresql.org>; Wed, 21 Nov 2007 10:23:08 -0300 (ART)
Received: from bugs.unl.edu.ar ([127.0.0.1])
	by localhost (bugs.unl.edu.ar [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id us10qIxAJ9s3 for <pgsql-sql@postgresql.org>;
	Wed, 21 Nov 2007 10:23:08 -0300 (ART)
Received: from [168.96.132.208] (bugs.unl.edu.ar [168.96.132.208])
	by bugs.unl.edu.ar (Postfix) with ESMTP id 3041923CB4D
	for <pgsql-sql@postgresql.org>; Wed, 21 Nov 2007 10:23:08 -0300 (ART)
Message-ID: <4744313C.40107@marquesminen.com.ar>
Date: Wed, 21 Nov 2007 10:23:08 -0300
From: Martin Marques <martin@marquesminen.com.ar>
User-Agent: IceDove 1.5.0.14pre (X11/20071018)
MIME-Version: 1.0
To: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: PL argument max size, and doubt
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.432 tagged_above=0 required=5 tests=AWL=0.431,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200711/101
X-Sequence-Number: 29629

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.