On Tue, 20 Oct 2015 21:57:59 +1100 rob stone <floriparob@xxxxxxxxx> wrote: > > Looking at this from an entirely different perspective, why are you not > using ICD codes to identify patient events? > It is a one to many relationship between patient and their events > identified by the relevant ICD code and date. > Given that MI has several applicable ICD codes you can use a select > along the lines of:- > WHERE icd_code IN ( . . . ) > > > I know it doesn't answer your question! It does indeed not answer my direct question, but it does offer an interesting perspecitive to be used on one of the next phases of the medical application. Thanks for the heads-up! > Cheers, > Rob Cheers, Tim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general