Re: do I need a table function to do this

[Bryan Lee Nuse <nuse@xxxxxxx>]

Hello Kirk,

Is this even possible?

It looks like if you could "un-pivot" your t2, then you could do a join between that result and t1 and have your desired table.  Others may be able to suggest a more direct solution, but I've successfully adapted the one given here, with my own wide-format tables:

https://cgsrv1.arrc.csiro.au/blog/2010/05/14/unpivotuncrosstab-in-postgresql/

Good luck,

Bryan