Re: Partial index with regexp not working

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Partial index with regexp not working
Дата
Msg-id 200709121954.36472.jgodoy@gmail.com
обсуждение исходный текст
Ответ на Re: Partial index with regexp not working  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
On Wednesday 12 September 2007 09:34:55 Richard Huxton wrote:

> To be honest, I'd probably just have a separate column "uid_type", set
> it when creating the user and then just have a partial index WHERE
> uid_type='IP'

Or have a separate column with the user ID and have "(anonymous)" when you
have the IP address on the table (maybe even NULL, it all depends on what you
want).


--
Jorge Godoy      <jgodoy@gmail.com>


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

Предыдущее
От: Jorge Godoy
Дата:
Сообщение: Re: ON UPDATE trigger question
Следующее
От: Cultural Sublimation
Дата:
Сообщение: Re: Cannot declare record members NOT NULL