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: | Raw Message | Whole Thread | 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 |