Title: Postgre: 8.0.1 Create Table insde a function gives strange error at execution time
Code within a function is like this:
SELECT 1
INTO x
FROM pg_tables
where tablename = 'globals_pac_adressarten'
and tableowner = user;
IF (NOT FOUND) THEN
CREATE TEMPORARY TABLE
Franz Stuetzle [EMAIL PROTECTED] writes:
ERROR: syntax error at or near $1 bei Zeichen 87
ANFRAGE: CREATE TEMPORARY TABLE globals_pac_adressarten (INT_ALIAS_NAME
VARCHAR(12) NOT NULL , $1 SMALLINT NOT NULL ,
$2 SMALLINT NOT NULL ) WITHOUT OIDS ON COMMIT PRESERVE ROWS
Would anybody know