Re: [GENERAL] Modifying search_path in a stored procedure

2005-01-11 Thread Tom Lane
Eric Brown <[EMAIL PROTECTED]> writes: > I know I can SET the schema search_path in a stored procedure, but is > there any way to retrieve it first so that I can get the current value > and manipulate that rather than just replace it? current_setting() would produce the value you want to give ba

Re: [GENERAL] Modifying search_path in a stored procedure

2005-01-11 Thread Michael Fuhr
On Tue, Jan 11, 2005 at 01:19:55PM -0800, Eric Brown wrote: > I know I can SET the schema search_path in a stored procedure, but is > there any way to retrieve it first so that I can get the current value > and manipulate that rather than just replace it? See the current_setting() and set_confi