Re: Setting week starting day - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Setting week starting day
Date
Msg-id 20070309172501.GD10875@alvh.no-ip.org
Whole thread Raw
In response to Re: Setting week starting day  (Jorge Godoy <jgodoy@gmail.com>)
Responses Re: Setting week starting day  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
Jorge Godoy escribió:

> Just to repeat my question:
>
> (I don't want to write a function, I can do that pretty easily...  And I was
> asking if there existed some feature on the database that...  It's just a
> curiosity)
>
>   Given a date X it would return me the first day of the week so that I can
>   make this first day an arbitrary day, e.g. Friday or Wednesday.

When you say "it would return", what's the "it"?

I wasn't proposing to use any function, just putting a simple expression
in the SELECT's result list (and maybe the GROUP BY, etc).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: HIPPA (was Re: Anyone know ...)
Next
From: Kenneth Downs
Date:
Subject: Re: HIPPA (was Re: Anyone know ...)