> Hi
> I have simple question: How to create view on a temporary table?
> I need this, because pl/pgsql function returns data via temporary table.
>
> View created on a temporary table is useful only to the end of session.
> Next time i create the same temp table i get
> "Table xxx with oid xxx doesn't exist"
Just name your temporary table the same name in every session. Why
bother with a view.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026