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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...
Дата
Msg-id 7287.1164249102@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: IS it a good practice to use SERIAL as Primary Key?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: IS it a good practice to use SERIAL as Primary Key?