On Thu, Feb 17, 2011 at 12:11 PM, Andreas Forø Tollefsen
wrote:
> Great. Thanks. Do you have a suggestion on how to ignore the group id's with
> 0 as value?
> I dont want these to be counted.
You can probably select your values in a subquery and filter out the 0
value results in the WHERE clause,
Great. Thanks. Do you have a suggestion on how to ignore the group id's with
0 as value?
I dont want these to be counted.
Thanks!
2011/2/17 bricklen
> On Thu, Feb 17, 2011 at 6:20 AM, Andreas Forø Tollefsen
> wrote:
> > Hi all!
> >
> > I have tried the below query, but i cannot find a way to s
On Thu, Feb 17, 2011 at 6:20 AM, Andreas Forø Tollefsen
wrote:
> Hi all!
>
> I have tried the below query, but i cannot find a way to select only
> DISTINCT into the ARRAY_AGG function. I also do not want 0 to be included in
> the array or 0 to be counted.
>
> Code:
>
> SELECT priogrid_land.gid, p
Hi all!
I am working on a query to identify which group ids exists within a spatial
cell. In this case i have the GREG table which has polygon data and the
priogrid_land which have the cell polygon.
I want to identify which and how many GREG group ids exists within each of
the priogrid_land cells.
