Search Postgresql Archives

Re: a JOIN on same table, but 'slided over'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Now, I'd like to make a JOIN-ed query of that table with itself, so that
I'd get rows paiwise: every row containing data from *two* rows of the
original TEST table so, that those data come from rows of consequtive
ID's - not neceserly (depending on the TEST table contents) continuesly
consequtive. Like:

SELECT * from view_of_test;
 id | id+X | thread | thread+X | info  | info+X
----+------+--------+----------+-------+---------
  2 |    3 |    763 |      764 | A     | B
  3 |    6 |    764 |        5 | B     | C
  6 |    8 |      5 |    88946 | C     | Cats
  8 |    9 |  88946 |    69315 | Cats  | Eifel
  9 |   10 |  69315 |    96379 | Eifel | G
-------------------------------------------------
Is there an SQL construct to get it?

I would use a plpgsql procedure, select all the rows ORDER BY id, keep the current and last row in a variable, and that's it.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux