Re: [postgis-users] Unique IDs in Views and Quantum GIS

2011-09-16 Thread pcreso
Phil James wrote: --- On Fri, 9/16/11, Phil James wrote: From: Phil James Subject: [postgis-users] Unique IDs in Views and Quantum GIS To: "postgis-users@postgis.refractions.net" Date: Friday, September 16, 2011, 10:12 PM I am trying to create a view that can be opened in

[postgis-users] Unique IDs in Views and Quantum GIS

2011-09-16 Thread Phil James
I am trying to create a view that can be opened in Quantum using ST_INTERSECTION.  This returns multiple entries for the same road object and therefore Quantum refuses to use the GID field as it is not unique.  As an alternative I thought to use row_number but this is a bigint and Quantum says