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
Thanks, Tom, for your helpful explanation and suggestions.
Now you're doubtless wondering why Postgres doesn't dodge this ambiguity
for you.
This is exactly what I was wondering, of course. And I follow the reasoning
behind why it cannot, at present. If Postgres can't ensure that the view
Greetings, list,
I have a VIEW I use to combine both acquired and missing field observations.
Because of they way these data will be used, missing values can't be NULL. So
I make them some outrageous integer value, like -999. I put the full VIEW
together using UNION.
As shown in the test
Is there anyone who has ever successfully gotten postgres/postGIS running on
Mac Lion? Really? How?
Hello Sam,
I'm running Lion, and had the same trouble using the Enterprise Stack Builder
to install PostGIS. I finally got it working by using Kyng Chaos' installers
for both PostgreSQL and