Skip site navigation (1) Skip section navigation (2)

plpgsql

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: plpgsql
Date: 2002-01-31 14:07:16
Message-ID: 3C594F94.8020605@geschwinde.net (view raw or flat)
Thread:
Lists: pgsql-novice
I have one question regarding pl/pgsql

I want to create a temporary tabel in an function

but:
SELECT INTO TMPORARY TABLE xxx FROM ...
creates an error because plpgsql thinks I'm trying to  assign the 
variable xxx
and then this is not the right syntax

Is there a workaround of this problem?

Ewald




pgsql-novice by date

Next:From: Sammer Reinhard J.Date: 2002-01-31 14:32:09
Subject: Re: column headers all in upper-case letters?
Previous:From: Sammer Reinhard J.Date: 2002-01-31 13:42:43
Subject: column headers all in upper-case letters?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group