Search Postgresql Archives

Re: 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Broersma Jr <rabroersma@xxxxxxxxx> writes:
> I just learned that about creating a static view using values for 8.2.  I was surpised to see that
> it worked.  My question is, where are these values stored?

In the text of the view definition.

> and Are there any limitations to the
> number of values that can be added?

I think you'd get unhappy with the performance for more than a few
thousand.  This isn't meant to be a substitute for a real table.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux