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

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Дата
Msg-id 36AC04C9-35B4-439F-B7C4-34FA9E4E3AE8@grid.unep.ch
обсуждение исходный текст
Ответ на Re: Normalized Tables & SELECT [was: Find "smallest common year"]  (Alban Hertroys <a.hertroys@magproductions.nl>)
Ответы Re: Normalized Tables & SELECT [was: Find "smallest common year"]  (Alban Hertroys <a.hertroys@magproductions.nl>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Poul Møller Hansen
Дата:
Сообщение: Dump of table structure is not consistent
Следующее
От: Stefan Schwarzer
Дата:
Сообщение: Re: Normalized Tables & SELECT [was: Find "smallest common year"]