Re: pg_class.relistemp - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: pg_class.relistemp
Date
Msg-id 4E1DB265020000250003F2BC@gw.wicourts.gov
Whole thread Raw
In response to Re: pg_class.relistemp  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: pg_class.relistemp
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> wrote:
> Unless you could make a kind of "view column" or something where the

> expression was `relpersistence <> 't'`.
create or replace function relistemp(rel pg_class) returns boolean language sql immutable strict as $$select
$1.relpersistence= 't';$$;
 
Just don't forget to use the table name or alias in front of it... :-)
-Kevin


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: pg_class.relistemp
Next
From: Robert Haas
Date:
Subject: Re: spinlock contention