Re: extract (dow/week from date)

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Clodoaldo Pinto <clodoaldo(dot)pinto(at)gmail(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: extract (dow/week from date)
Date: 2005-08-21 16:59:04
Message-ID: 20050821165904.GK95876@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Aug 21, 2005 at 08:00:45AM -0300, Clodoaldo Pinto wrote:
> Of course it would be even better if we could pass parameters to the
> functions changing its behavior such as sunday/monday as the first day
> or 0-1 as the first day.

FWIW, it seems most things that support changing first day of the week
to be something other than <default> do it through a global setting.
ISTM that would be much less error prone than having to make sure you
used it in all your function calls (not to mention a lot less typing...)
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-08-21 17:01:22 Re: ORDER BY time consuming
Previous Message Stephan Szabo 2005-08-21 16:38:50 Re: [GENERAL] Cascades Failing