Problems with views

Поиск
Список
Период
Сортировка
От mazzo
Тема Problems with views
Дата
Msg-id 000c01c0f42d$d6eb3ba0$0100a8c0@slackmachine
обсуждение исходный текст
Список pgsql-general
Hi all..i'm trying to create some views on which i have to execute some queries...the problem is that i get errors saying that a field has already been specified..To make it more clear: i have a table called testing with these fields..a b c d e..I created 1 view like:
 
create view one as
select a,c,e from testing where a <100
 
and this one works fine...
If i try to create another view eg:
 
create view two as
select * from testing
 
I get the error that i mentioned above..saying that a field c has already been specified...
 
Is there a solution??
 
Thanks in advance!

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: Log files, how to rotate properly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Compilation of contrib of postgresql 7.1.2 with cygwin 1.3.2