[GENERAL] Runtime error when calling function from .NET ( Function returns record)

2007-01-15 Thread dparent
I have a function which returns TYPE RECORD and receives a string. The passed string is used to build a dynamic SQL statement and the passed string is the SELECT LIST of the built dynamic SQL statement. The call works fine from Postgres SQL (PL/PG SQL) but when I make the call from .NET (Core

[GENERAL] Function which returns record

2007-01-11 Thread dparent
I am looking to have the select list passed into a function at runtime and use this select list to build SQL to execute, for example: CREATE or REPLACE FUNCTION public.test2( IN _sfieldlist varchar) RETURNS SETOF pg_catalog.record AS $BODY$ DECLARE v_feed RECORD; v_sfieldlist