Re: [GENERAL] Problem with selecting the first day of the the week

2008-10-29 Thread Raymond O'Donnell
On 29/10/2008 20:11, x asasaxax wrote: >I need a function to select the first day of the week. For example > giving today´s date(29/10/2008). select 'Monday'; ;-) Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedr

Re: [GENERAL] Problem with selecting the first day of the the week

2008-10-29 Thread Pavel Stehule
Hello try CREATE OR REPLACE FUNCTION public.fdow(date) RETURNS date LANGUAGE sql IMMUTABLE STRICT AS $function$ select $1 - extract(dow from $1)::int $function$ postgres=# select fdow(current_date); fdow 2008-10-26 (1 row) regards Pavel Stehule 2008/10/29 x asasaxax <[EMAI