Re: limit table to one row

g == gryzman(at)gmail(dot)com writes:

g> 2009/6/9 Brandon Metcalf <brandon(at)geronimoalloys(dot)com>:

g> > I'm not sure I follow how this solves the problem.

g> Well, surely if you just need one row, you need single value per key.
g> And that's the, imo , better solution to that problem, than limiting
g> number of rows.

Hm. Maybe I'm looking at the problem incorrectly. I have a situation
where I need a table like

CREATE TABLE foo (
start DATE,
length VARCHAR(10),
);

I need to be able to get one value for each column at any given time.
Specifically, I need to get a value for start and add the value for
length to get a time period. Since your approach would allow more
than one row, how does it help me?

--
Brandon