| From: | "OisinJK" <oisin(dot)kelly(at)landscapeplanning(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Create View from command line |
| Date: | 2010-05-10 09:43:44 |
| Message-ID: | B7C9076DA2096E4BAB98EC256764D44DDBB016@colchester01.LPGL.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I'm trying to build a Windows Form application that needs to alter the
definition of a View, depending on user input/selection. Essentially,
the user is selecting a property of known coordinates ('x','y') and
setting a 'buffer' distance . I then want to retrieve the records which
represent the map features within the specified distance of the
property. The WHERE clause of my view is:
st_dwithin(mytable.geom, st_setsrid(st_point(x, y), 27700), buffer);
I'm thinking this could be achieved either by making x, y and buffer
parameters or, I simply ALTER the View statement with literal values.
Whichever, I need to do this from a command line attached to a windows
form event, e.g. button_click.
I cannot work out how to do this. Can anyone point me in the right
direction. I've looked at psql.exe, but can't work out if this holds the
answer.
Thanks
Oisin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2010-05-10 09:50:25 | Re: Finding rows with text columns beginning with other text columns |
| Previous Message | AI Rumman | 2010-05-10 04:52:21 | Re: question about unique indexes |