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