do $$ declare selected_film film%rowtype; input_film_id film.film_id%type := 0; begin select * from film into selected_film where film_id = input_film_id; if not found then raise notice'The film % could not be found', input_film_id; end if; 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