"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> It has little bit strange behave on 8.3. It works well, but I have to
> use casting.
> postgres=# select substring('1234' from to_number('3', '99')::int for 3);
> substring
> ---
> 34
> (1 row)
Yeah, the OP is getting burnt by an implici
Hello
It has little bit strange behave on 8.3. It works well, but I have to
use casting.
postgres=# select substring('1234' from to_number('3', '99') for 3);
ERROR: function pg_catalog.substring(unknown, numeric, integer) does not exist
LINE 1: select substring('1234' from to_number('3', '9
