enter|LITES Contract
(757) 224-4074
-Original Message-
From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84
Sent: Tuesday, July 19, 2011 3:37 AM
To: Thornton, Susan M. (LARC-B702)[LITES]
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Help with
Hi Sue,
If I understand correctly, you have the map in a file.
How about loading the map into a temporary table
CREATE TEMPORARY TABLE handle_map (
id integer,
handle varchar(20),
) ON COMMIT DROP;
COPY handle_map FROM '/path/to/map.txt' DELIMITERS '|' CSV;
and then doing what you need in SQL?
Susan:
Using a subquery you can get the handle. You need to figure out how to
include only the handle of the items you are going to delete: I just
can't find a simple way using only SQL. Maybe you should consider
programming a PL/pgSQL function.
select substring(mv.text_value,33,8),ha.handle
I am trying to write a SQL query (in PostgreSQL) that will create a delete-map
file for duplicate records we’ve inadvertently imported into a special instance
of DSpace version 1.5.1 we have. Of course the delete map has to be in the
following format:
{any-number} | handle of the record to b
4 matches
Mail list logo
