Re: FW: [SQL] Function

2004-02-17 Thread Richard Huxton
On Tuesday 17 February 2004 14:41, Sumita Biswas (sbiswas) wrote: > Is there nothing like SET NOCOUNT ON; in plpgsql What is this supposed to do for you? > Is there any option like SET ANSI_NULLS ON in plpgsql. What is this supposed to do for you too? > Do we append # before the temp table name

FW: [SQL] Function

2004-02-17 Thread Sumita Biswas (sbiswas)
Is there nothing like SET NOCOUNT ON; in plpgsql Is there any option like SET ANSI_NULLS ON in plpgsql. Do we append # before the temp table names in plpgsql, like we do for MSSQL ? In case no how do we create a temp table in a function in plsql? -Original Message- From: Stephan Szabo [m