Re: SQL Challenge: Skip Weekends - Mailing list pgsql-sql

From Josh Berkus
Subject Re: SQL Challenge: Skip Weekends
Date
Msg-id web-1552107@davinci.ethosmedia.com
Whole thread Raw
In response to Re: SQL Challenge: Skip Weekends  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Joe,

> How about this (a bit ugly, but I think it does what you want --
> minus the holidays, which you said you already have figured out):
> 
> create or replace function
>   get_future_work_day(timestamp, int)

Thank you.  Once again, you come to the rescue when I'm stuck.  I'll
try your solution and Jean-Luc's, and see which works better/faster. And report back.

-Josh Berkus


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: skip weekends
Next
From: Dirk Lutzebaeck
Date:
Subject: Can somebody help me to optimize this huge query?