Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams

[Karsten Hilbert]

On Fri, Feb 19, 2010 at 09:51:24AM -0800, Jim Busser wrote:

> Referring to the screen shot in the last posting, I tried
> 
>       CREATE UNIQUE INDEX "main"."statusUnique" ON "status" ("DRUG_CODE" ASC, 
> "HISTORY_DATE" DESC)
> 
> but it failed,

Sure, because there can be several entries with the same
HISTORY_DATE which violates the UNIQUE assertion.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346