[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 lab

[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_sfi