Hi,
Just to fix the sql:
data "geom FROM (SELECT TO_NUMBER(<idcolumn>) AS id,
<geoom_column> as geom FROM <table>) USING UNIQUE id"
Best regards.
------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
Fernando Simon wrote:
Hi François,
You can do this with the to_number in you sql, like:
data "geom FROM (SELECT TO_NUMBER(<idcolumn>) AS id FROM
<table>) USING UNIQUE id"
To use this way the idcolumn must need to store only numbers.
Best regards.
------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------
François Prunayre wrote:
Hello, when using UNIQUE with an Oracle Spatial Layer we have to
"must pass
a numeric column type" ... When we have a table with a primary key
type VARCHAR ... Is there any way to
use UNIQUE without changing the data model ? ROWID is not numeric,
ROWNUM is
numeric but it's not an identifier ... So should not work.
Any ideas ?
Thanks. Francois
