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 <[email protected]> > > 2010/5/24 郭家成 <[email protected]> > > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
