create function get_film_count(len_from int, len_to int) returns int language plpgsql as $$ declare film_count integer; begin select count(*) into film_count from film where length between len_from and len_to; return film_count; end; $$; Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter