Re: Normalized Tables & SELECT [was: Find "smallest common year"]

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: Alban Hertroys <a(dot)hertroys(at)magproductions(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Date: 2007-10-01 14:17:15
Message-ID: 36AC04C9-35B4-439F-B7C4-34FA9E4E3AE8@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> BTW, You didn't actually use type text for your year column, did
> you? No
> quotes needed then. Otherwise you'd have to make sure your year values
> are all the same length or sorting gets... interesting.

Yep, my comment just before concerns especially this paragraph, I
guess. With not only years but also time spans for my data - so, not
only 1970, 1971.... but also 1970-75, 1975-80 etc. I would need
indeed to use text for my year column. Why get sorting than
"interesting"?

Stef

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2007-10-01 14:28:38 Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Previous Message Stefan Schwarzer 2007-10-01 14:13:23 Re: Normalized Tables & SELECT [was: Find "smallest common year"]