Hello!
I am trying to create a sql function that returns 2
values using temporary table as the "media":
database1=# CREATE FUNCTION SaveNumeric(int2,int2)
RETURNS INTEGER AS '
database1'# CREATE TEMP TABLE mytemp(a int2,b int2);
database1'# INSERT INTO mytemp VALUES ($1+1,$2+100);
database1'# SELECT 1;
database1'# ' LANGUAGE 'sql';
ERROR: Relation 'mytemp' does not exist
But below seems to work:
database1=# CREATE FUNCTION Drop2Numeric() RETURNS
INTEGER AS '
database1'# DROP TABLE mytemp;
database1'# SELECT 1;
database1'# ' LANGUAGE 'sql';
CREATE
Why the creation of SaveNumeric(int2,int2) fails
while the creation of Drop2Numeric() succeeds?
Regards,
CN
--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com