[SQL] Postgre: 8.0.1 Create Table insde a function gives strange error at execution time

2005-03-27 Thread Franz Stuetzle
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

Re: [SQL] Postgre: 8.0.1 Create Table insde a function gives strange error at execution time

2005-03-27 Thread Tom Lane
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