Re: ERROR: invalid value "????" for "YYYY" - Mailing list pgsql-general

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]