0

I need pl/sql return count of the table .. pass by reference the name of table and name of field

i´m using:

-- Function: fn_post_gera_chave_numerica(character varying, character varying)

-- DROP FUNCTION fn_post_gera_chave_numerica(character varying, character varying);

CREATE OR REPLACE FUNCTION fn_post_gera_chave_numerica(
    var_nm_tabela character varying,
    var_nm_campo character varying)
  RETURNS integer AS
$BODY$

--1o. Parameter: Table
--2o. Parameter: Fields

DECLARE
        var_sql    character varying;
        var_id     numeric; 
BEGIN

    var_sql:= 'SELECT into var_id max('|| $2 || ') FROM ' || $1; 

    execute var_sql;
        
    RETURN var_id;      
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION fn_post_gera_chave_numerica(character varying, character varying)
  OWNER TO postgres;


SELECT fn_post_gera_chave_numerica('tblcadlinhacelular', 'ccodigo');
2
  • 1
    I’m voting to close this question because it written in not english Commented Apr 11, 2022 at 18:19
  • Please write your answer in English, as Stack Overflow is an English-only site. Commented Apr 12, 2022 at 6:08

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.