DT, David G. Johnston
wrote:
On Monday, April 29, 2019, Daniil Treshchin wrote:
INTEGER is "higher" than CHARACTER VARYING, so the expressions will be
validated to INTEGER and not to CHARACTER VARYING. Why, because the engine
picked it this way for you.
You invented the “higher
selected in step (2). Correction from the last email I checked, the value
expression is not evaluated itself but it is "analyzed" to the highest datatype
or exception is thrown during various, not obvious conditions.
Thank you.
On Monday, April 29, 2019, 10:26:58 PM PDT, David G. Jo
bout that statement about evaluation, but there
is still a problem in here as you can see from this confusion. It evaluates the
type of the s.
Thank you,
On Monday, April 29, 2019, 6:31:16 PM PDT, Daniil Treshchin
wrote:
Hi Bruce, David.
Comment: "Without further elaboration as to t
Hi Bruce, David.
Comment: "Without further elaboration as to the shortcomings"
I provided a clear description on why, but for some reason it was missed in
this thread.
Here it is:
The COALESCE(, ..., ) scans the list of
s from left to right, determines the highest data type inthe
list and ret
