From: Tod McQuillin <devin@spamcop.net>
To: frederic massot <frederic@juliana-multimedia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL syntax
Date: Wed, 7 Aug 2002 01:48:58 +0900 (JST)
Message-ID: <20020807014416.F3278-100000@glass.pun-pun.prv> (raw)
In-Reply-To: <3D4FEB4C.3D4D06ED@juliana-multimedia.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: devin@spamcop.net, frederic@juliana-multimedia.com
Subject: Re: SQL syntax
In-Reply-To: <20020807014416.F3278-100000@glass.pun-pun.prv>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox