Re: [mapserver-users] Help with failing Postgis query...

2019-02-12 Thread Brent Wood
to, processed by and stored on NIWA's IT systems. From: mapserver-users on behalf of Lime, Steve D (MNIT) Sent: Wednesday, February 13, 2019 08:39 To: Stephen Woodbridge; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Help with failing Postgis query

Re: [mapserver-users] Help with failing Postgis query...

2019-02-12 Thread Lime, Steve D (MNIT)
To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Help with failing Postgis query... Brent, Are you wrapping your query like: DATA "select * from (select ROW_NUMBER() OVER (order by code) as id, code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as F

Re: [mapserver-users] Help with failing Postgis query...

2019-02-10 Thread Stephen Woodbridge
Brent, Are you wrapping your query like: DATA "select * from (select ROW_NUMBER() OVER (order by code) as id, code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as Family, point from rdb.species_master s, maps.null_point p where code in (select distinct species from

[mapserver-users] Help with failing Postgis query...

2019-02-10 Thread Brent Wood
Hi, I'm getting an error with an SQL in a mapfile. The query works from from the command line: select ROW_NUMBER() OVER (order by code) as id, code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as Family, point from rdb.species_master s, maps.null_point p where code in