From: Alfonso Peniche <alfonso@iteso.mx>
To: pgsql-general@postgresql.org
Subject: temp table creation
Date: Wed, 14 Feb 2001 19:09:27 -0600
Message-ID: <3A8B2C47.465BBF9@iteso.mx> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: alfonso@iteso.mx, pgsql-general@postgresql.org
Subject: Re: temp table creation
In-Reply-To: <3A8B2C47.465BBF9@iteso.mx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox