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!
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 |