Re: [GENERAL] Reliably finding temporary table

2005-06-10 Thread Michael Fuhr
On Tue, Jun 07, 2005 at 04:01:02PM -0700, Ian Burrell wrote: > > CREATE OR REPLACE FUNCTION test_date_time_exists() RETURNS BOOLEAN AS ' > BEGIN > RETURN EXISTS ( > SELECT * FROM pg_class > WHERE relname = ''test_date_time'' > AND pg_table_is_visibl

Re: [GENERAL] Reliably finding temporary table

2005-06-10 Thread Dan Black
Help! I have a similar problem. Does anybody know how to solve a problem2005/6/8, Ian Burrell <[EMAIL PROTECTED]>: We have some functions which need to dynamically create a temporarytable if it does not already exist.  We use the following function:CREATE OR REPLACE FUNCTION test_date_time_exists()