Re: BUG #3848: function pg_catalog.substring(date, integer, integer) does not exist - Mailing list pgsql-bugs

Sam Mason <sam@samason.me.uk> writes:
> I've just downloaded the source of tinyerp and had a look though and
> this practice seems pretty endemic.  They should really be using
>   to_char(date_exp, 'YYYY-MM')
> instead of
>   substring(date_exp FOR 7)
> in all their queries.

Or at least explicitly casting the date to text.  But your way is
better, since it won't break if the datestyle is something other
than ISO.

            regards, tom lane