Re: how to check presence of a function and set permissions? - Mailing list pgsql-sql

From Tod McQuillin
Subject Re: how to check presence of a function and set permissions?
Date
Msg-id Pine.GSO.4.33.0105210350290.3446-100000@sysadmin
Whole thread Raw
In response to how to check presence of a function and set permissions?  (bboett@erm1.u-strasbg.fr (Bruno Boettcher))
Responses Re: how to check presence of a function and set permissions?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
On Mon, 21 May 2001, Bruno Boettcher wrote:

> since i am now destroying and recreating my functions at every request
> (due to the fact that pl/psql can't cope with dynamic table names,

I don't know about the rest of your question but I believe PostgreSQL
supports dynamic queries in plpgsql since v7.1 --

EXECUTE 'SELECT * FROM ' || table_name || ' WHERE whatever';

However, I do not see it in the documentation, so now I'm not 100%
certain.
-- 
Tod McQuillin




pgsql-sql by date:

Previous
From: bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Date:
Subject: how to check presence of a function and set permissions?
Next
From: Cedar Cox
Date:
Subject: Re: Case insensitive string comparison?