network profile
| bio | website | |
|---|---|---|
| location | Florida | |
| age | 38 | |
| visits | member for | 2 years |
| seen | Aug 9 '12 at 18:13 | |
| stats | profile views | 3 |
|
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? |
