[Qgis-user] postgis/gresql views

[James Keener]

I guess I don't fully understand your problem. Is this a labeling issue or a postgres issue?

Also, labels can be the output of an expression. I don't know if that's what you mean as you're also talking about aggregate functions.

Can you more clearly define your problem?

Jim

On December 9, 2015 1:08:47 AM EST, Matt Boyd <mattslists at gmail.com> wrote:
>Hi QGISers.
>I'm trying to work out how to display some geological data on map.
>Basically
>Table x;
>location1 | zone1 | date1 | value1
>location1 | zone1 | date2 | value2
>continued with variations in location/zone etc..
>
>spatial table
>geometry Column | location1
>
>
>I create a view in postgresql using the location as the common column.
>However, when I try to display my data, zone2 is shown with value1 and
>I
>can't work out how to get 2 values and 2 zones to display at a time.
>
>All the data is there and shown correctly in the combined attributes
>table,
>however labels don't show correctly.
>
>Ideally I'd like to be able to create labels and views from within qgis
>using functions (eg, for all zones in location1, what is the sum of the
>values).
>
>I've only been at this a couple of hours this afternoon but thought I'd
>check here in case there's a simpler solution than the one I'm heading
>towards.
>
>Thanks
>Matt
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Qgis-user mailing list
>Qgis-user at lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151209/e4c02bec/attachment.html>