Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7DDA5475A50 for ; Tue, 6 Aug 2002 12:49:39 -0400 (EDT) Received: from mail.distalzou.net (203.141.139.231.user.ad.il24.net [203.141.139.231]) by postgresql.org (Postfix) with ESMTP id C613E476205 for ; Tue, 6 Aug 2002 12:49:14 -0400 (EDT) Received: from localhost ([127.0.0.1]) by mail.distalzou.net with esmtp (Exim 3.36 #1) id 17c7Vz-000P9U-00; Wed, 07 Aug 2002 01:49:00 +0900 Date: Wed, 7 Aug 2002 01:48:58 +0900 (JST) From: Tod McQuillin X-X-Sender: devin@glass.pun-pun.prv To: frederic massot Cc: pgsql-sql@postgresql.org Subject: Re: SQL syntax In-Reply-To: <3D4FEB4C.3D4D06ED@juliana-multimedia.com> Message-ID: <20020807014416.F3278-100000@glass.pun-pun.prv> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/108 X-Sequence-Number: 8954 On Tue, 6 Aug 2002, frederic massot wrote: > 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 ? given m = 8: select * from mois order by case when id_mois < (m + 10) % 12 then id_mois + 13 else id_mois end; -- Tod McQuillin