Re: Drawbacks of using BYTEA for PK?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Drawbacks of using BYTEA for PK?
Date: 2004-01-16 17:31:37
Message-ID: 200401161731.i0GHVb416369@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Garamond wrote:
> Nigel J. Andrews wrote:
> > I can't comment on the real content of this discussion though since a) I
> > haven't be reading it and b) I probably wouldn't know what it was on about if
> > I had been.
>
> Um, any insight on the original question (see subject)? :-)

A bytea join will use a bytea indexed column just fine, I think.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Ramsey 2004-01-16 17:36:57 Adding long text to a database text field generates errors
Previous Message Marco Lazzeri 2004-01-16 17:19:32 Integer ranges in PostgreSQL