temp table creation

From: Alfonso Peniche <alfonso(at)iteso(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: temp table creation
Date: 2001-02-15 01:09:27
Message-ID: 3A8B2C47.465BBF9@iteso.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

What's wrong with this function? The syntax is supposed to be right,
isn't it?

Create function UsaTablaTemporal()
RETURNS integer
AS '
BEGIN

SELECT p.apellidos, p.nombres, u.username
INTO TEMP TABLE mitabla
FROM persona p, usuario u
WHERE p.idpersona = u.idusuario
AND p.idpersona = 3278;

RETURN 1;

END;'
LANGUAGE 'plpgsql';

If I run:
select usatablatemporal();

I get the message:
ERROR: parser: parse error at or near "temp"

Thanx

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2001-02-15 01:54:51 Re: temp table creation
Previous Message Vince Vielhaber 2001-02-14 22:50:03 Re: 404 Error on Documentation Page

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-15 01:54:51 Re: temp table creation
Previous Message Leon Sol Levy 2001-02-14 23:56:30 creating assertions in functions