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.