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(at)gmail(dot)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!
>