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	May 11, 2011 12:26:33
Msg-id	SNT135-w216811A0AC929E9C7FC035CF860@phx.gbl Whole thread Raw
Responses	Re: Query to return every 1st Sat of a month between two dates Re: Query to return every 1st Sat of a month between two dates Re: Query to return every 1st Sat of a month between two dates Re: Query to return every 1st Sat of a month between two dates
List	pgsql-general

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

From: Phoenix Kiula
Date: 11 May 2011, 12:23:27
Subject: Regexp match not working.. (SQL help)

From: Tom Lane
Date: 11 May 2011, 12:31:29
Subject: Re: full text search to_tsquery performance with ispell dictionary