Re: Partial index with regexp not working

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partial index with regexp not working
Date: 2007-09-12 22:54:36
Message-ID: 200709121954.36472.jgodoy@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cultural Sublimation 2007-09-12 22:56:27 Re: Cannot declare record members NOT NULL
Previous Message Jorge Godoy 2007-09-12 22:52:51 Re: ON UPDATE trigger question