Search Postgresql Archives

do I need a table function to do this

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have been given an interesting problem to solve in a postgres db. I was given two tables

t1:


site		treatment		variable		id (pk)
-------------------------------------------------------------
A		X				BLUE		1A
B		Y				RED		2B
A		Y				GREEN		3A



t2:

rowid (pk)	timestamp		BLUE		RED		GREEN
-----------------------------------------------------------------------------------------
1			1332493200		3.4			2.1			5.8
2			1332496800		3.2			2.0			5.8
3			1332500400		3.3			2.2			6.0


I need to combine the site and treatment information from t1 with the variable records in t2. I think I will have to combine these one variable at a time. Something like this (I'm not using the word join, because I don't think this is a join in the regular sense. It's more like some kind of crazy pivot table thing!):

t3:

rowid (pk)	timestamp		BLUE		site 		treatment
-------------------------------------------------------------------------------------
1			1332493200		3.4			A		X
2			1332496800		3.2			A		X
3			1332500400		3.3			A		X

and then:

t4

rowid (pk)	timestamp		RED		site 		treatment
-------------------------------------------------------------------------------------
1			1332493200		2.1			B		Y
2			1332496800		2.0			B		Y
3			1332500400		2.2			B		Y


Is this even possible?





-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux