Re: USMARC and postgresql? - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: USMARC and postgresql?
Date
Msg-id Pine.LNX.4.10.10005090920500.17232-100000@chapelperilous.net
Whole thread Raw
In response to Re: USMARC and postgresql?  (Andrew Sullivan <sullivana@bpl.on.ca>)
List pgsql-general
On Tue, 9 May 2000, Andrew Sullivan wrote:

> BLOBs.  It's a pain, though, because building the indices against the
> catalogue is difficult.  I think, actually, that the PICK-based spproach is
> better, but PICK is going away.  Anyway, you likely need to talk to someone
> about BLOBs.  I can't help, sorry.

The MARC format is really intended to be used in a full-text search
environment, such as the old online systems like Dialog or Lexix-Nexis use
(although they don't use MARC specifically).  They all predate SQL and
mapping one onto the other is not an easy task.  It's easy to go from a
SQl database to one of the variable-length (or 80 column card image)
text-formats, but not the other way around unless you are into doing some
text-processing programming.

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
If the very old will remember, the very young will listen.
        -- Chief Dan George


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: USMARC and postgresql?
Next
From: "Samuel A. Mullen"
Date:
Subject: Postgres Tool Question