[Info-ingres] When is an empty string an integer?

[Martin Bowes]

Hi All,

This is probably documented behaviour but I'm having a hard time finding it. So if someone could point me at the document I'd be happy.

What is the expected result of: select integer(varchar('', 1))

The answer is zero.

I must concede I can sort of see this as being necessary, but I'm curious as to why we just didn't get the standard error:
E_US100F String cannot be converted to numeric due to incorrect syntax.

Martin Bowes




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20160511/f6482a1d/attachment.html>