[mapserver-users] MapServer and Guid USING UNIQUE

[Tamas Szekeres]

2011/3/18 Roger Bedell <sylvanascent at gmail.com>

> I found this:
>
> SELECT (select count(*) from QQHeader where PKey<=a.PKey) AS RowNo, a.*
> FROM QQHeader AS a
>
>

The problem with this (and with the ROW_NUMBER option as well) is that the
order of the rows may be undeterministic unless an orderby clause is used. I
would rather suggest to use a function (either an UDF or the checksum) to
create and integer is from guid.

BTW: In the development version having an oid should not necessarily be a
requirment in order to have the query option to work. So you may probably
omit the using unique section in the layer definition (not tested by me).

Best regards,

Tamas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110318/391884a8/attachment-0001.html