From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | me(at)alternize(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: help with date_part & day of week |
Date: | 2005-12-30 02:36:43 |
Message-ID: | 200512300236.jBU2ahb17497@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
me(at)alternize(dot)com wrote:
> > You can really do it using CASE:
> >
> > CASE
> > WHEN dow() = 0 THEN 6
> > ELSE dow() - 1
> > END
>
> how good is this solution in regards to performance? i always thought CASE
> and the such should only be used for last resorts. and now there is also a
> date function involved that gets twice in 6/7 of all cases...
>
> regarding these concerns, can you give me your opinion on this solution i
> came up:
>
> SELECT ((date_part('dow', now()) + 6) % 7) AS weekday
I don't think CASE is any significant performance hit, certainly less
than a pl/pgsql function. Anyway, your solution looks even cleaner.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-12-30 02:45:18 | Re: ecommerce soolution |
Previous Message | Christopher Browne | 2005-12-30 02:18:29 | Re: ecommerce soolution |