Re: [GENERAL] Passing array of range literals

2014-03-21 Thread David Johnston
Glenn Pierce wrote > I cannot work out how to pass a literal for the array of timerange types. > '{(15:11:21, 18:11:21)}'::timerange[] does not work for example. > Also I can not pass NULL for this parameter I get since NULL can take on any type if you pass it literally you have to specify the typ

[GENERAL] Passing array of range literals

2014-03-21 Thread Glenn Pierce
Hi I am try to create a function that returns true if a timestamp is within working hours. The function will take the following parameters. 1, timestamp - The timestamp I want to check 2, days_of_week - An array of integers that tells us what days are work days. 3, time_ranges - An array of my c