You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
To me this doesn't look right. The previous test seems correct. When putting a negation in front of interval I believe it should negate the entire interval statement.
interval '5' - '1' - '2' year is one interval statement.
I think the statement
select -interval '5' - '1' - '2' year;
Should be interpreted as:
select - (interval '5' - '1' - '2' year);
Rather than
select (- interval '5') - '1' - '2' year;
If the user wants to negate only 5, they should write it as follows (below are all equivalents):
interval '5' - '1' - '2' year
is one interval statement.I think the statement
Should be interpreted as:
Rather than
If the user wants to negate only
5
, they should write it as follows (below are all equivalents):Originally posted by @aprimadi in #6698 (comment)
The text was updated successfully, but these errors were encountered: