Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 9.6.24 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit

SELECT 1

create table job(id int);
insert into job values(1);

INSERT 0 1

DO
$$
declare ct timestamp := '2020-09-04 23:59:59';
begin
select CT,5 from job;
end;
$$

ERROR:  query has no destination for result data
HINT:  If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT:  PL/pgSQL function inline_code_block line 4 at SQL statement

create or replace function func() returns table(col1 timestamp, col2 int )
as

$$
declare ct timestamp := '2020-09-04 23:59:59';
begin
return query
select CT,5 from job;
end;
$$

language plpgsql

CREATE FUNCTION

select * from func()

col1
col2

2020-09-04 23:59:59
5

SELECT 1