/* current_schemas_setof.c  

   external C function as SRF to return OIDs of schemas in search 
   path. Schemas returned in the same order as current_schemas().

   Experimental code, use at own risk...

   After compiling, create function like this:
 
   CREATE OR REPLACE FUNCTION current_schemas_setof()
   RETURNS setof OID
   AS '/path/to/current_schemas_setof.so'
   LANGUAGE 'C';
*/

#include "postgres.h"
#include "nodes/execnodes.h"
#include "catalog/namespace.h"

#define MAX_SCHEMAS 16  /* FIXME: what would be a safe figure? */

typedef struct {
	Oid oid[MAX_SCHEMAS];
    int ptr;
	int total; /* total oids */
} CS_results;

CS_results *
  init_results(MemoryContext fn_mcxt);

PG_FUNCTION_INFO_V1(current_schemas_setof);

Datum
current_schemas_setof(PG_FUNCTION_ARGS)
{
	ReturnSetInfo	*rsi;
	CS_results      *results;
 	List            * search_path = fetch_search_path(TRUE);
	int             current;

	if (fcinfo->resultinfo == NULL || !IsA(fcinfo->resultinfo, ReturnSetInfo))
		elog(ERROR, "current_schemas_setof: function called in context that does not accept a set result");


	if (fcinfo->flinfo->fn_extra == NULL)
	{
		/*
		 * save pointer to results for the next time round
		 */
		results = init_results(fcinfo->flinfo->fn_mcxt);

		/*
		 * add OIDs of schemas in search path to result array
		 */

		while (search_path && results->total < MAX_SCHEMAS)
		{
			results->oid[results->total] = (Oid) lfirsti(search_path);
			results->total ++;
			search_path = lnext(search_path);
		}
		results->ptr = 0;
		fcinfo->flinfo->fn_extra = (void *) results;

		rsi = (ReturnSetInfo *) fcinfo->resultinfo;
		rsi->isDone = ExprMultipleResult;

		/*
		 * return first OID
		 */

		results->ptr = 1;
		PG_RETURN_OID(results->oid[0]);
	}
	else
	{
		results = fcinfo->flinfo->fn_extra;

		if(results->ptr < results->total) {
			
			current = results->ptr;
			results->ptr ++;
			rsi = (ReturnSetInfo *) fcinfo->resultinfo;
			rsi->isDone = ExprMultipleResult;

			PG_RETURN_OID(results->oid[current]);
		}
		else {

			/*
			 * no more results: clean up
			 */

			results = fcinfo->flinfo->fn_extra;
			results->ptr = 0;
			results->total = 0;
			pfree(results);
			fcinfo->flinfo->fn_extra = NULL;

			rsi = (ReturnSetInfo *) fcinfo->resultinfo;
			rsi->isDone = ExprEndResult;

			PG_RETURN_NULL();
		}


	}
	PG_RETURN_NULL();
}


CS_results *
init_results(MemoryContext fn_mcxt)
{
	MemoryContext oldcontext;
	CS_results *retval;

	oldcontext = MemoryContextSwitchTo(fn_mcxt);

	retval = (CS_results *) palloc(sizeof(CS_results));
	MemSet(retval, 0, sizeof(CS_results));

	retval->ptr = 0;
	retval->total = 0;

	MemoryContextSwitchTo(oldcontext);

	return retval;
}
