Postgres Pro
Downloads
Home   >   mailing lists

Query to return every 1st Sat of a month between two dates - Mailing list pgsql-general

From Alex -
Subject Query to return every 1st Sat of a month between two dates
Date
Msg-id SNT135-w216811A0AC929E9C7FC035CF860@phx.gbl
Whole thread Raw
Responses Re: Query to return every 1st Sat of a month between two dates  (Michael Nolan <htfoot@gmail.com>)
Re: Query to return every 1st Sat of a month between two dates  ("David Johnston" <polobo@yahoo.com>)
Re: Query to return every 1st Sat of a month between two dates  (Osvaldo Kussama <osvaldo.kussama@gmail.com>)
Re: Query to return every 1st Sat of a month between two dates  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-general
Tree view
Hi,
is there an easy way to return the date of every first Saturday of a month in a data range i.e. 2011-2013

Any help would be appreciated

Thanks
Alex 

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Regexp match not working.. (SQL help)
Next
From: Tom Lane
Date:
Subject: Re: full text search to_tsquery performance with ispell dictionary