Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 447EB475B1C for ; Tue, 6 Aug 2002 11:30:12 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id D5793475B07 for ; Tue, 6 Aug 2002 11:30:11 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 4637938195B; Tue, 6 Aug 2002 11:29:11 -0400 (EDT) From: frederic massot X-Newsgroups: comp.databases.postgresql.sql Subject: SQL syntax Date: Tue, 06 Aug 2002 17:29:16 +0200 Organization: Juliana =?iso-8859-1?Q?Multim=E9dia?= Lines: 53 Message-ID: <3D4FEB4C.3D4D06ED@juliana-multimedia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: news@hub.org X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.4.18 i686) X-Accept-Language: fr-FR, fr, en To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/103 X-Sequence-Number: 8949 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===