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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
