DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=lkE8KhABbIwyN07kfrE0Uoxem8D6LmALTuWjy38+GN6AOq868ff6V9fXnHh/UxIPLoPUBLXVZk38wncrbBzDQtDNEalmWIN/qZbc54bSFcARC66CplYBemLx3ja9hRwqY/sBR+dhDHdA7TE4qsv7oVVvhktq7atowyOHdYtdxUo=
Message-ID: <a55915760711210729t7d255de2kf0abc309ffd84ccc@mail.gmail.com>
Date: Wed, 21 Nov 2007 10:29:15 -0500
From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" <rdeleonp@gmail.com>
To: "Martin Marques" <martin@marquesminen.com.ar>
Subject: Re: PL argument max size, and doubt
Cc: "PostgreSQL SQL List" <pgsql-sql@postgresql.org>
In-Reply-To: <4744313C.40107@marquesminen.com.ar>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4744313C.40107@marquesminen.com.ar>

On Nov 21, 2007 8:23 AM, Martin Marques <martin@marquesminen.com.ar> wrote:
> (BTW, which it that limit if it exists?).

"In any case, the longest possible character string that can be stored
is about 1 GB."

See:
http://www.postgresql.org/docs/8.2/static/datatype-character.html

> 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.

I don't think EXECUTEing sets FOUND to true. Try:

CREATE OR REPLACE FUNCTION
  DATOGRANDE(TEXT)
RETURNS BOOLEAN AS $$
BEGIN
  INSERT INTO FUNCDATOGRANDE VALUES (DEFAULT,$1);
  IF FOUND THEN
    RETURN TRUE;
  ELSE
    RETURN FALSE;
  END IF;
END;
$$ LANGUAGE 'PLPGSQL';