[postgis-users] Create View From Spatial Table with libpq

[Mike Toews]

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.

-Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100524/4de1c9d3/attachment.html>