Hi all,
Sorry for following up to my own mail. I went over the function again
and realized I was exceeding the size I had allocated for the query
string. Never realised I was exceeding the varchar(1000) that I had
declared as the string.
Apologies for my last follow-up to my query, I sent it fro
, 2001 1:15 PM
Subject: [GENERAL] error while generating and EXECUTEing a query dynamically
> Hi all,
>
> The machine I am sending this mail from does not have postgres, but I
> did this just this morning so am typing from memory:
>
>
>
> CREATE FUNCTION footable() RETUR
Hi all,
The machine I am sending this mail from does not have postgres, but I
did this just this morning so am typing from memory:
CREATE FUNCTION footable() RETURNS INTEGER AS '
DECLARE
sql VARCHAR(1000);
BEGIN
sql := ''CREATE TABLE foo (x INT, y CHAR) '';
EXECUTE sq
