Postgres Pro
Downloads
Home   >   mailing lists

Re: do I need a table function to do this - Mailing list pgsql-general

From Bryan Lee Nuse
Subject Re: do I need a table function to do this
Date
Msg-id BA8E345938B48C42A2F124851A65C00B41C992D6@BL2PRD0210MB349.namprd02.prod.outlook.com
Whole thread Raw
In response to do I need a table function to do this  (Kirk Wythers <kwythers@umn.edu>)
List pgsql-general
Tree view
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:



Good luck,
Bryan

pgsql-general by date:

Previous
From: Serge Fonville
Date:
Subject: Re: do I need a table function to do this?
Next
From: terenceng
Date:
Subject: Re: Installing pgAgent with MS Windows