Opened 14 years ago
Closed 14 years ago
#2662 closed patch (fixed)
[Patch] custom query in postgres provider
| Reported by: | brushtyler | Owned by: | nobody |
|---|---|---|---|
| Priority: | minor: annoyance | Milestone: | Version 1.5.0 |
| Component: | Data Provider | Version: | Trunk |
| Keywords: | custom query, postgres | Cc: | |
| Must Fix for Release: | No | Platform: | All |
| Platform Version: | Awaiting user input: | no |
Description
The patch permit you to load a postgres layer using a custom query, like
SELECT * FROM tbl1 JOIN tbl2 ON tbl1.gid = tbl2.id WHERE tbl1.gid > 15 LIMIT 10 OFFSET 15 .
The new layer have only select capabilities.
The only limit is that no columns with the same name must be in the result.
Attachments (2)
Change History (3)
by , 14 years ago
| Attachment: | patch.diff added |
|---|
by , 14 years ago
| Attachment: | query.diff added |
|---|
modified patch (some additions/cleanups; eg. allow subset strings)
Note:
See TracTickets
for help on using tickets.
patch