Actually, it would appear that I was born yesterday. I had no idea.
Added the cast and it fell right in. Thanks!
chris <-- feeling pretty dumb right now
On Sat, 2004-01-03 at 00:57, Tom Lane wrote:
> Chris Trawick <ctrawick(at)cultured(dot)net> writes:
> > contactid | bigint | not null
> > Am I reading this right? Is it only using half of the fully-qualified
> > pk index? How do I diagnose this? Has anyone seen this before?
> Surely you've been around here long enough to remember the
> must-cast-bigint-constants problem.
> regards, tom lane
In response to
pgsql-performance by date
|Next:||From: D. Dante Lorenso||Date: 2004-01-04 01:18:34|
|Subject: Indexing a Boolean or Null column?|
|Previous:||From: Tom Lane||Date: 2004-01-03 05:57:54|
|Subject: Re: "fun with multipart primary keys" hobby kit |