Hi,
ya, that is the background of this story.
There is one internal app in my company that frequently runs into specific error - related to that query.
Its actually not Devs team who reject to look at this but support team (which is one step before devs)
So, now showing them this same query with added to_char() they should "shut-the-front-door" and send it to correction.
...though its really difficult with them.
Anyway thank you all for your help :)
BR,
czezz
Dnia 5 maja 2015 16:47 Scott Ribe <scott_ribe@elevated-dev.com> napisał(a):
> On May 5, 2015, at 8:21 AM, czezz <czezz@o2.pl> wrote:
> >
> > This is because this query is executed/hardcoded in application.
> > And by executing it like this I can prove devs that there is a problem.
>
> So you were really looking for an explanation of why it didn’t work, in order to pass along to people whom you’re
havingtrouble convincing? OK, didn’t get that from your post, now it makes sense. It just seemed odd that you seemed to
beignoring the most correct (and easy) solution ;-)
>
> Anyway, now the we understand that… PostgreSQL used to be more aggressive about automatically casting text types to
morespecific types. I suspect, though I don’t recall for sure, that this query would have worked on some earlier
versions.Later versions removed some of the automatic casting, because it was found that those casts caused
problems—thatsometimes they would cause accidental type mismatches to be executed instead of flagged, and produce
incorrectresults instead of an error message, so the decision was made that if you want to compare mismatched types,
youhave to be explicit about it.
>
>