Postgres Pro
Downloads
Home   >   mailing lists

Re: Partial index with regexp not working - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Partial index with regexp not working
Date
Msg-id 200709121954.36472.jgodoy@gmail.com
Whole thread Raw
In response to Re: Partial index with regexp not working  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: ON UPDATE trigger question
Next
From: Cultural Sublimation
Date:
Subject: Re: Cannot declare record members NOT NULL