For loop over VALUES

do $$ declare i int; j int; begin for i,j in (values(1,2),(2,3),(3,4))  loop raise NOTICE '%, %', i,j; end loop; end; $$

Select * from VALUES / Using VALUES in SELECT

Very useful when you need to use list of your values in FOR cycle etc. One column in row: select * from (values('myValue01'),('myValue02'),('myValue03')) as t(column1)   More columns in row: select * from (values('myValue01', 1),('myValue02', 2),('myValue03', 3))...