Message-ID: <44DBD05C.9020800@acm.org>
Date: Thu, 10 Aug 2006 17:33:32 -0700
From: TJ O'Donnell <tjo@acm.org>
Reply-To: tjo@acm.org
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: sql error creating function
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

When I psql -f f.sql
I get the following error:
psql:f.sql:10: ERROR:  relation "fragset" does not exist
CONTEXT:  SQL function "fragments"

 > cat f.sql
Create Or Replace Function fragments(character varying)
  Returns setof character varying
As $$

Create Temporary Table fragset (smiles character varying);
Insert into fragset Values ('COCNC');
Insert into fragset Values ('COCNCc1ccccc1');
Select smiles from fragset;

$$ Language SQL;

But, if I paste into a running psql the commands:

Create Temporary Table fragset (smiles character varying);
Insert into fragset Values ('COCNC');
Insert into fragset Values ('COCNCc1ccccc1');
Select smiles from fragset;

it works fine.

What is wrong in the function definition?
I'm using 8.1.3

Thanks,
TJ O'Donnell