I tried creating this FUNCTION and get the error;
SQL Error : Unterminated dollar quote started at position 0 in SQL $BODY$. Expected terminating $$
Has anyone tried creating function that acts like a stored procured in CrateDB?
create or REPLACE function databasnamee.GET_DATA_FUNC_TABLE() returns table ( v_id character varying, vi_firstname character varying )
LANGUAGE 'PLPGSQL' AS $BODY$ begin return QUERY select ID,firstname from databasename.functiontest; end; $BODY$;