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

From Tom Lane
Subject Re: 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...
Date
Msg-id 7287.1164249102@sss.pgh.pa.us
Whole thread Raw
In response to 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Richard Broersma Jr <rabroersma@yahoo.com> 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

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Next
From: Tom Lane
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?