Re: Blob question -(((

On Mon, 1 Jan 2001, Boris wrote:

> Here are my questions:
>
> * Are they any limits to the OID Datatype? I need 50-100k per row.

50-100k COLUMNs per row?  Or are you talking about binary files of
50-100K?  You definitely need to use the large object fetaures of
PostgreSQL.

> * Can I do fulltext-search with OID fields (VERY IMPORTANT QUESTION!!!!)?

OIDs are just numbers.  If you are using them for large objects, they are
just 'pointers' to the binary data of a file maintained by the operating
system.  If you need to search, you should design your database with
apprpriate description or keyword fields.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Be circumspect in your liaisons with women.  It is better to be seen at
the opera with a man than at mass with a woman.
        -- De Maintenon