ORACLE / Using unique

[Fernando Simon]

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
>>
>>
>>  
>>
>
>