|
Graphical query builder resets functions and joins
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
|
