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]
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
