103 reputation
2
bio website
location Florida
age 39
visits member for 3 years, 6 months
seen Aug 9 '12 at 18:13

May
13
awarded  Popular Question
May
3
awarded  Scholar
May
3
accepted Query PostgreSQL 9.0 table on foreign key value?
May
3
comment Query PostgreSQL 9.0 table on foreign key value?
Thanks for the suggestions. I worry that I might have oversimplified my example as the colors are, in real life, geographic polygons and multi-polygons. Not sure it would make sense to store their geometry-type values repeatedly.
May
3
comment Query PostgreSQL 9.0 table on foreign key value?
Thanks for pointing me toward the 'using' syntax. That is tidier. Using the code from the code/value pairs works out fine except when building reports, especially on aggregate values. Again, I must have been overestimating the power of the FK relationship.
May
3
comment Query PostgreSQL 9.0 table on foreign key value?
@Catcall - I suppose I've always assumed the foreign key constraint provides for more than just referential integrity, that applying the constraint lends the user some query-construction advantage that I just couldn't figure out. Just assumed I haven't been taking full advantage of the FK relationship.
Apr
28
asked Query PostgreSQL 9.0 table on foreign key value?