From: | Wouter Boasson <Wouter(dot)Boasson(at)rivm(dot)nl> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Graphical query builder resets functions and joins |
Date: | 2009-09-29 12:51:25 |
Message-ID: | OFFAB38D6A.EF563858-ONC1257640.0044EC26-C1257640.0046A02F@notesmail.rivm.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Applies to PgAdmin 1.10.0, PostGIS (in general)
When working with geodata (using PostGIS in PostgreSQL) its often
neccessary to make joins that are not regular joins (see the example
below), and use all kinds of special processing functions. It is not
possible to enter them in the graphical query builder which would be a
great enhancement.
The real problem is that, when entering the SQL manually using functions,
and you switch to the graphical query builder, it can't handle this and
crashes. Or it doesn't crash, but when returning to the SQL-editor tab the
information entered manually is lost. I hope that this can be solved!
Example function in the "SELECT" clause:
SELECT zipcode, ST_PointOnSurface(shape)
This could be part of a "WHERE" clause to join two tables spatially:
ST_Intersects(nl.adm_pc4_2009.shape, nl.adm_gem_2008_lw.shape)
Furthermore, the query builder should be able to deal with grouping etc.
Regards,
Wouter
Disclaimer RIVM
From | Date | Subject | |
---|---|---|---|
Next Message | Niklas Olsson | 2009-09-29 13:25:17 | Export server list |
Previous Message | Arthur Knight Hammer | 2009-09-29 12:43:11 | Re: How to use pgAdmin 3 |