[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams |
Date: |
Fri, 19 Feb 2010 22:56:23 +0100 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
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
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, (continued)
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Sebastian Hilbert, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- [Gnumed-devel] Rethinking drug reference, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Rethinking drug reference, Karsten Hilbert, 2010/02/23
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams,
Karsten Hilbert <=
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/21
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/21