Problems with views

From: "mazzo" <jambo(at)aruba(dot)it>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problems with views
Date: 2001-06-13 17:25:28
Message-ID: 000c01c0f42d$d6eb3ba0$0100a8c0@slackmachine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Browse pgsql-general by date

  From Date Subject
Next Message Nils Zonneveld 2001-06-13 17:25:46 Re: Newbie question: How to check how many tables avaliable at that database?
Previous Message Dave Cramer 2001-06-13 17:20:02 Log files, how to rotate properly