Answers for "postgres for each"

SQL
0

foreach postgres

do
$$
declare
	rec record;
begin
	for rec in select title, length 
			from film 
			where length > 50
			order by length
	loop
		raise notice '% (%)', rec.title, rec.length;	
	end loop;
end;
$$Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
Posted by: Guest on October-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language