Re: query has no destination for result data

I believe language plpgsql is not considered part of the function body
> so it is not included in the line count:
>
> https://www.postgresql.org/docs/10/plpgsql-structure.html
>
> When tracking a line number down I usually do:
>
> \ef some_function line_number
>
> which counts the line in the function body not the file. So for example:
>
> Using set nu in Vi:
>
> 1 CREATE OR REPLACE FUNCTION public.ts_update()
> 2 RETURNS trigger
> 3 LANGUAGE plpgsql
> 4 AS $function$
> 5 BEGIN
> 6 NEW.ts_update := timeofday();
> 7 RETURN NEW;
> 8 END;
> 9 $function$
>
> \ef ts_update 4
>
> CREATE OR REPLACE FUNCTION public.ts_update()
> RETURNS trigger
> LANGUAGE plpgsql
> AS $function$
> BEGIN
> NEW.ts_update := timeofday();
> RETURN NEW; <--- This row is marked
> END;
> $function$
>
>
or

\sf+ functioname

Regards

Pavel