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

[郭家成]

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 <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.
>
> -Mike
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100524/688a4b37/attachment.html>