Re: Complex query - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Complex query
Date
Msg-id 20140331185542.GB10833@leonardo-laptop
Whole thread Raw
In response to Re: Complex query  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: Complex query
List pgsql-general
On 2014-03-31 18:48:58 +0000, Igor Neyman wrote:
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> > owner@postgresql.org] On Behalf Of Leonardo M. Ramé
> > Sent: Monday, March 31, 2014 2:38 PM
> > To: PostgreSql-general
> > Subject: [GENERAL] Complex query
> >
> > Hi, I'm looking for help with this query.
> >
>
> Leonardo,
>
> Unless you add one more column to your Tasks table, specifically: StatusTimestamp as in:
>
> IdTask  StatusCode  StatusName StatusTimestamp
>
> You cannot find which record in the table follows which, because order in which records returned from the database is
notguaranteed until you add "ORDER BY" clause to your SELECT statement. 
>
> Regards,
> Igor Neyman
>
>

You are right, let's add the Id column. This is just an example, the
real table (a view) contains both, the Id and a timestamp:

Id IdTask  StatusCode  StatusName
----------------------------------
1  1       R           Registered
2  1       S           Started
3  1       D           Dictated
4  1       F           Finished
5  1       T           Transcribed
----------------------------------
6  2       R           Registered
7  2       S           Started
8  2       T           Transcribed
9  2       F           Finished

After adding the Id column, can I use a window function to get what I
need?.

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: Moshe Jacobson
Date:
Subject: Wanted: ALTER TRIGGER ... OWNED BY EXTENSION
Next
From: Si Chen
Date:
Subject: getting the current query from pg_stat_activity