Ireneusz Pluta writes:
> [ Postgres accepts timestamp input of the form '2011-07-22 :' ]
> Some other datetime parsers reject it, the Perl DateTime::Format::Pg is an
> example.
> Is this case a subject of eventual corrections in the future versions of
> postgres and it would start emit errors t
Hi,
consider the following:
select quote_literal(blank_hms) as "quote_literal(blank_hms)", blank_hms::timestamp as
"blank_hms::timestamp" from (select unnest(array['2011-07-22 :', '2011-07-22 : ', '2011-07-22 : :
']::text[]) as blank_hms) a; select version();
quote_literal(blank_hms) | blan
Hi,
consider the following:
select quote_literal(blank_hms) as "quote_literal(blank_hms)", blank_hms::timestamp as
"blank_hms::timestamp" from (select unnest(array['2011-07-22 :', '2011-07-22 : ', '2011-07-22 : :
']::text[]) as blank_hms) a; select version();
quote_literal(blank_hms) | blan
