"Mario Alberto Soto Cordones" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION "public"."contador_distrito_activos" (numeric, > numeric, numeric) RETURNS SETOF "public"."ty_activo" AS' > declare > con bigint; > act bigint; > ... > return con , act;
plpgsql has no shorthand for constructing a rowtype result, as you seem to be expecting here. Declare a variable of type ty_activo, fill it in, and return it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]