[GENERAL] two-column primary key (not the typical question)

2012-07-06 Thread Chip Nowacek
I need a suggestion. I need a two-column primary key that does not depend on the order of the entries. That is, for the purposes of the key: PKColA PKColB foobar barfoo is not valid. Any help would be appreciated.

[GENERAL] array vs bit fields for masking

2012-06-17 Thread Chip Nowacek
Hey. I'm new to postgresql. Impressive. I am building an app with core tables in a central schema and user access via views in separate schemas. I have to manage versioning and system configuration at the row level. My initial thinking was to have a bit field for each quality: version BIT(20), con