[postgis-users] Create View From Spatial Table with libpq
iron1103 at gmail.com
Mon May 24 02:33:35 PDT 2010
Hey Mike, I made a mistake.
I tried to create a function to create view, but Postgre still gave me that
errmsg, "there is no parameter $1".
I think there is only one solution in my case:
1. Create a table that only has one geometry column
2. Insert a geometry
3. Create View
4. Drop that table
Do u have better idea?
Thank you for your enthusiastic !
郭家成 <iron1103 at gmail.com> 於 2010年5月24日下午4:04 寫道：
> Thanks a lot, Mike ! That's a great hint.
> I made a windows application, that allow user to browse spatial tables, and
> a view by dragging a rectangle on my application.
> $1 is that rectangle made by user.
> Can I create a temporary geometric object ? How to do that ?
> 2010/5/24 Mike Toews <mwtoews at gmail.com>
>> 2010/5/24 郭家成 <iron1103 at gmail.com>
>> So, everything works fine without "CREATE VIEW", weird.
>> I should have seen that earlier .. views don't have parameters, so that is
>> why test 1-4 don't work. Views need to have existing columns. What is $1
>> supposed to be? A geometry column from a different table, or the same table?
>> If you needs are only temporary, then explore the uses of "select * into
>> *temp *tt from ..." then use tt like any other table until you don't need
>> it anymore in the transaction, then it disappears out of sight.
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users