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 ! 郭家成 <iron1...@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 > create > 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 <mwto...@gmail.com> > >> >> 2010/5/24 郭家成 <iron1...@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. >> >> -Mike >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users