On Thu, Nov 21, 2013 at 10:31 AM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:
> I will give you an example:
>
> Given a normal select
>
> select * from table mytable where ....
>
> If this table has business time support it would be
>
> select * from table mytable as of business_time of '2011-01-01' where ....
>
> The syntax extension is in the "from" clause. The above query returns only
> records valid at '2011-01-01'. A simple
>
> select * from table mytable where ...
>
> would return all historical versions, this is unwanted in most scenarios.
> If the date is missing it should be
>
> select * from table mytable as of business_time of current time where ...
>
> This select returns all actual versions.
>
Hmm... seems pretty close to what GeoServer is doing when time is activated
on vector data, without need for
any special database support:
* if you specify a date range in TIME, it will add that as a search clause
* if you don't specify any, it will use the most current time in the
database... the only thing is that it will take time to extract it, which
is likely suboptimal
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
