Hello,
I have a table containing the months of the year :
travail=> select * from mois order by id_mois;
id_mois|mois_fr |mois_en |mois_de
-------+---------+---------+--------- 1|Janvier |January |Januar 2|Fevrier |February |Februar 3|Mars
|March |Marz 4|Avril |April |April 5|Mai |May |Aber 6|Juin |June |Juni
7|Juillet |July |Juli 8|Aout |August |August 9|Septembre|September|September 10|Octobre |October
|Oktober 11|Novembre |November |November 12|Decembre |December |Dezember
(12 rows)
And I try to obtain for one month given (for example August : 8) two
previous months, the current month, and nine next months :
id_mois|mois_fr |mois_en |mois_de
-------+---------+---------+--------- 6|Juin |June |Juni 7|Juillet |July |Juli 8|Aout
|August |August 9|Septembre|September|September 10|Octobre |October |Oktober 11|Novembre |November
|November 12|Decembre |December |Dezember 1|Janvier |January |Januar 2|Fevrier |February |Februar
3|Mars |March |Marz 4|Avril |April |April 5|Mai |May |Aber
Do you see how making in a SQL request ?
Thank you.
--
==============================================
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:frederic@juliana-multimedia.com |
===========================Debian=GNU/Linux===