Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'

Поиск
Список
Период
Сортировка
От Ian Sillitoe
Тема Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'
Дата
Msg-id c6ff42340804030300i6846880dra7b62b116ae6211d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'  (Ted Byers <r.ted.byers@rogers.com>)
Список pgsql-general
Дерево обсуждения

> We are annotating nodes on a hierarchical structure
> where NULL implied an

I don't mean to be rude, but yuck.  Why provide a
record for data that isn't there?

No offence taken - I'm trying to improve an old (partially inherited) system, hence the original post.

I have no idea if this model would work for you, but
maybe it will help.

That approach all sounds sensible, however going through the links that Richard Broersma sent over in a previous post - I'm currently leaning towards the flexibility and intuitive interface that ltree contrib module appears to offer.

http://www.postgresql.org/docs/8.3/interactive/ltree.html

Cheers,

Ian

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: simple update queries take a long time - postgres 8.3.1
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: is it helpful for the optimiser/planner to add LIMIT 1