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
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: 3436
Logged by: FAGOT Alain
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Win32
Description:inherited primary keys are not reported as primary key
by the Java DatabaseMetaData
Deta
"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
"FAGOT Alain" <[EMAIL PROTECTED]> writes:
> Description:inherited primary keys are not reported as primary key
> by the Java DatabaseMetaData
There's no such thing as an inherited primary key. See
http://www.postgresql.org/docs/8.2/static/ddl-inherit.html#DDL-INHERIT-CAVEATS
Hi, All,
I'm working on a GIS project using PostgreSQL and PostGIS. In the project I
need to find locations of about 12K addresses (the process is referred to as
geocoding). I wrote some script to perform this task by calling a procedure
"tiger_geocoding" that is provided by PostGIS. My script