gnumed-devel
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Jim Busser
Subject: Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams
Date: Fri, 19 Feb 2010 09:51:24 -0800 
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, whereas

        CREATE INDEX "main"."statusUnique" ON "status" ("DRUG_CODE" ASC, 
"HISTORY_DATE" DESC)

was accepted.

Also I suppose

        SELECT DISTINCT

is not right for this situation (?)
reply via email to
[Prev in Thread] Current Thread [Next in Thread]