title: how would i print out multiple columns from a stored procedure in plpgsql
body: <p>I am trying to print multiple columns in a stored procedure...can anyone please provide me with an example that uses a query. Thank you. </p>
  
  <p>K for example, I have a movie database and I want to find the percentage of the profitable movies of all movies since the year 1960. I have the queires that do that and I ran it on pgADMIN and it works perfectly; however when i try creating a stored procedure, I know I have to use create a type holder as ( yr INTEGER, prnct FLOAT). </p>
  
  <p>So now with that I need to create a stored procedure that would return the two columns one of the year and one of the percent, however how do i that this column is the yr and the next column is prnct.</p>