querying for groups of data with similar properties
От | Lonni J Friedman |
---|---|
Тема | querying for groups of data with similar properties |
Дата | |
Msg-id | BANLkTi=BgDH4J-VboB=DrF9CBSZXGeE3Tg@mail.gmail.com обсуждение исходный текст |
Список | pgsql-novice |
Greetings, I have a table full of automated test data, which continuously has new unique data inserted: Column | Type | Modifiers ----------------+-----------------------------+------------------------------------------------------------- id | integer | not null default nextval('dbltests_id_seq'::regclass) testname | text | not null last_update | timestamp without time zone | not null default now() current_status | text | not null os | text | not null arch | text | not null build_type | text | not null branch | text | not null The 'testname' column contains many different tests, and each unique 'testname' has numerous different associated os,arch,build_type & branch values. For example, testname='foo' will run on os='Linux',arch='i686',build_type='debug',branch='t38', and also on os='Windows7',arch='x86_64',build_type='release',branch='r40', etc, and there will be many other different testname's with similar permutations of the os,arch,build_type & branch columns. The current_status column is either 'PASSED' or 'FAILED'. What I'm struggling with is how to put together a SQL query which shows me all instances of a given testname permutation (os,arch,build_type,branch) which has a current_status value of 'FAILED' for two or more consecutive 'last_update' values. Suggestions welcome. thanks in advance! Lonni
В списке pgsql-novice по дате отправления: