"Peter Hardman" <[EMAIL PROTECTED]> writes: > On 17 Aug 2006 at 14:33, Tom Lane wrote: >> I found a couple of minor planner problems, which I've repaired in CVS >> HEAD. You might consider using TEXT columns instead of VARCHAR(n),
> As someone else suggested, these fields ought really to be CHAR no VARCHAR. That should be fine too. VARCHAR is sort of a poor stepchild in Postgres, because it piggybacks on TEXT's operators --- but CHAR has different comparison rules, hence its own operators, hence doesn't trip over that bug. There's still some things that don't add up to me, like the question of the pkey column order. Will look some more. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly