Joseph Adams <joeyadams3(dot)14159(at)gmail(dot)com> writes:> This isn't exactly a bug, but it could be considered unintuitive> behavior.
It's required by the SQL standard.
regards, tom lane