Tuesday, 20 August 2013

Formatting database when using multiple criteria

Formatting database when using multiple criteria

This should be a relatively simple question. I come from a Python
background and don't do a lot of SQL stuff so thought I would ask this
formatting question here.
Say I've got something that has
Criteria 1: True
Criteria 2: False
Criteria N: True
In Postgresql, is it better to set the database up as:
Column: Criteria
Row: [1:True,2:False,N:True]
or set each criteria as a column of its own?

No comments:

Post a Comment