"David E. Wheeler" <da...@kineticode.com> wrote: > On Jul 13, 2011, at 12:57 PM, Kevin Grittner wrote: > >> 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... :-) > > Oh, nice hack. How far back does that work (pgTAP runs on 8.0 and > higher)? As far as I know, the technique of creating a function with a record type as its only parameter to use as a "generated column" goes way back. This particular function won't work prior to 9.1, because you won't have the relpersistence column, but then, prior to 9.1 you wouldn't need to run this because you already have a relistemp column. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers