[Qgis-user] Help on creating a view

[Jürgen E. Fischer]

Hi Francis,

On Thu, 29. May 2008 at 07:40:22 -0700, Francis Dupont wrote:
> SELECT a.gid, b.gid, a.level, b.name a.the_geom
> FROM myPolyTable a, myPtTable b
> WHERE st_contains(a.the_geom, b.the_geom)
> ORDER BY a.level, a.gid;

You could may get away with:

SELECT
    (a.gid::int8<<32)+b.gid::int8 as gid,
    a.gid, b.gid, a.level, b.name a.the_geom
  FROM
    myPolyTable a,
    myPtTable b
  WHERE 
    st_contains(a.the_geom, b.the_geom)
  ORDER BY
    a.level, a.gid;
 

Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-0
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502