Re: [SQL] PL argument max size, and doubt

2007-11-23 Thread Martin Marques
Tom Lane escribió: Martin Marques <[EMAIL PROTECTED]> writes: Tom Lane escribió: Martin Marques <[EMAIL PROTECTED]> writes: I have always heard that modification queries should be EXECUTED in PL. AFAICR. Run far away from whatever source gave you that advice... Sorry, it was with DDL comma

Re: [SQL] PL argument max size, and doubt

2007-11-22 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > Tom Lane escribió: >> Martin Marques <[EMAIL PROTECTED]> writes: >>> I have always heard that modification queries should be EXECUTED in PL. >>> AFAICR. >> >> Run far away from whatever source gave you that advice... > Sorry, it was with DDL commands

Re: [SQL] PL argument max size, and doubt

2007-11-22 Thread Martin Marques
Tom Lane escribió: > Martin Marques <[EMAIL PROTECTED]> writes: > >> I have always heard that modification queries should be EXECUTED in PL. >> AFAICR. > > Run far away from whatever source gave you that advice... Sorry, it was with DDL commands. ---(end of broadcast)--

Re: [SQL] PL argument max size, and doubt

2007-11-21 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > Rodrigo De León escribió: >> "In any case, the longest possible character string that can be stored >> is about 1 GB." >> > I was asking about the limit in the argument. Is it the same as the > limits the types have in table definition? Yeah, ultima

Re: [SQL] PL argument max size, and doubt

2007-11-21 Thread Martin Marques
Rodrigo De León escribió: 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-charact

Re: [SQL] PL argument max size, and doubt

2007-11-21 Thread Rodrigo De León
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

[SQL] PL argument max size, and doubt

2007-11-21 Thread Martin Marques
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 funcdatogra