Complex query - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Complex query
Date
Msg-id 20140331183815.GA10833@leonardo-laptop
Whole thread Raw
Responses Re: Complex query
Re: Complex query
Re: Complex query
List pgsql-general
Hi, I'm looking for help with this query.

Table Tasks:

IdTask  StatusCode  StatusName
----------------------------------
1       R           Registered
1       S           Started
1       D           Dictated
1       F           Finished
1       T           Transcribed
----------------------------------
2       R           Registered
2       S           Started
2       T           Transcribed
2       F           Finished

As you can see, I have a table containing tasks and statuses. What I
would like to get is the list of tasks, including all of its steps, for
only those tasks where the StatusCode sequence was S followed by T.

In this example, the query should only return task Nº 2:

2       R           Registered
2       S           Started
2       T           Transcribed
2       F           Finished

Can anybody help me with this?.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: char array overhead
Next
From: David Johnston
Date:
Subject: Re: Complex query