"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
The following bug has been logged online:
Bug reference: 3435
Logged by: Carlos Quintero
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux RedHat Enterprise 3
Description:problem with substring function
Details:
Hi,
I like to use a
