On 03/09/13 12:55, John Callahan wrote:
> As FYI, to create a valid idExpression (one without a leading integer
> and not using a CQL function), I need to create a column in my database
> view to represent the id. An example output of id would be
> "fid.sand.898". I concatenated fields in my Postgres view as below.
> CREATE myView AS
> SELECT (('fid.'::text || datatable."formationCode"::text) || '.'::text)
> || spatialtable.gid AS id, .....
Good, that is just what I do. Much better than CQL in the mapping file.
Although I have not yet used them (only in Oracle), PostgreSQL 9.3 has
materialised views (although there has been a community recipe out for a
while):
http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-materialized-views/
Matviews give you the option of indexing your string-concatenated id for
improved performance. Don't forget to index your other columns, as a
matview does not copy indexes or constraint!
Kind regards,
--
Ben Caradoc-Davies <[email protected]>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
