m fix and it's have nothing to do with your data.
>
> Basically in my case, SunOS 5.8 ( dunno what Solaris version is that,
> probably 8 )
> PG was crashing during cost calculation, long before any data access.
>
>
>
> -----Original Message-
> From: Luis Magaña
year ALIAS FOR $1;
week ALIAS FOR $2;
endsin TIMESTAMP;
BEGIN
SELECT INTO endsin
(SELECT CAST(year || ''-01-01'' AS TIMESTAMP) -
(date_part(''dow'',CAST(year || ''-01-01'' AS TIMES
Hi,
how can I get the first and last day of a week given the year and the
week number ???
example
week 3 of 2003 starts in Jan 12th and ends on Jan 18th.
how to know the last two values given the year and the number of week ?
thanks.
Best Regards.
--
Luis Magaña.
Gnovus Networks
ly my question.
Thanks for the help.
Best Regards.
--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
