| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |