On Nov 21, 2007 8:23 AM, Martin Marques <[EMAIL PROTECTED]> 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'; ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
