From: | "Wim Ceulemans" <wim(dot)ceulemans(at)nice(dot)be> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | ERROR: using an explicit cast |
Date: | 1998-12-09 14:19:17 |
Message-ID: | 003201be237e$e87c3c20$67faa8c0@aladdin.nice.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all
I am using postgres 6.3.2 and I experience problems using a union on views
In short, I have the following views defined:
create view vstockpart as select 'StockPart' as vpisource, pspid as
vpisourceid;
create view vquoteoutitem as select 'QuoteOutItem' as vpisource, fqoiid as
vpisourceid;
where pspid and fqoiid are both of type int.
When I launch the following query:
select vpisource,vpisourceid from vstockpart union select
vpisource,vpisourceid from vquoteoutitem;
then I get the following error:
NOTICE: there is no more then one operator < for types
NOTICE: unknown and unknown. You will have to retype this query
ERROR: using an explicit cast.
Where can I find documentation regarding casts?
Does anybody know what is wrong? Or do I have to move to 6.4?
TIA
Wim Ceulemans - wim(dot)ceulemans(at)nice(dot)be
Nice Software Solutions
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 41 29 53 - Fax +32(0)15 41 29 54
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Chernev | 1998-12-10 05:09:13 | libpg++ documentation |
Previous Message | Marcin Grondecki | 1998-12-09 05:15:09 | AIX 4.1 & plpgsql |