How to get the data from the query

What is the value you are expecting?  What is the minimal table definition (i.e., a one or few column table) that would produce this expected value?  What does psql show if you use it to output the query against that table?

David J.