Re: Problem with selecting the first day of the the week - Mailing list pgsql-general

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 <xanaruto@gmail.com>:
> Hi,
>
>    I need a function to select the first day of the week. For example
> giving  today´s date(29/10/2008).
>
> Can anyone help´s me?
> Thanks!
>