From: Scott Ribe <scott_ribe@elevated-dev.com>
To: czezz <czezz@o2.pl>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: Postgres Maillist <pgsql-admin@postgresql.org>
Subject: Re: display to_timestamp in quotas or convert to char ?
Date: Tue, 5 May 2015 08:47:38 -0600
Message-ID: <CA0B2CA1-D2CB-490C-A394-8D3BC376A59A@elevated-dev.com> (raw)
In-Reply-To: <79bfc5f9.244b3aa3.5548d1d4.9c8af@o2.pl>
References: <22c93a48.7dc1250c.5548946d.f29b0@o2.pl>
<A737B7A37273E048B164557ADEF4A58B365FC46A@ntex2010a.host.magwien.gv.at>
<70aed348.7ad50e54.5548c47d.1e1de@o2.pl>
<FA3EDC66-B5A8-461F-8EAD-48124674C7BB@elevated-dev.com>
<79bfc5f9.244b3aa3.5548d1d4.9c8af@o2.pl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 having trouble convincing? OK, didn’t get that from your post, now it makes sense. It just seemed odd that you seemed to be ignoring the most correct (and easy) solution ;-)
Anyway, now the we understand that… PostgreSQL used to be more aggressive about automatically casting text types to more specific 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—that sometimes they would cause accidental type mismatches to be executed instead of flagged, and produce incorrect results instead of an error message, so the decision was made that if you want to compare mismatched types, you have to be explicit about it.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, czezz@o2.pl, laurenz.albe@wien.gv.at
Subject: Re: display to_timestamp in quotas or convert to char ?
In-Reply-To: <CA0B2CA1-D2CB-490C-A394-8D3BC376A59A@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox