> -----Original Message----- > From: Leonardo M. Ramé [mailto:l.r...@griensu.com] > Sent: Monday, March 31, 2014 2:56 PM > To: Igor Neyman > Cc: PostgreSql-general > Subject: Re: [GENERAL] Complex query > > On 2014-03-31 18:48:58 +0000, Igor Neyman wrote: > > > -----Original Message----- > > > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > > > ow...@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 not guaranteed 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
D.Johnston showed how to use windows function in this case. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
