On 08/10/2013 23:03, Rowan Collins wrote:
> With tables_with_dates As (
> select table_name, to_date(right(table_name, 8), 'YYYYMMDD') blah
> from information_schema.tables
> where table_schema = '????'
> and table_catalog = '????'
> )
> Select table_name, blah
> Where blah > '2013-01-01'::date
Oops, there should be a "From tables_with_dates" in there, obviously :|
--
Rowan Collins
[IMSoP]