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
create view vquoteoutitem as select 'QuoteOutItem' as vpisource, fqoiid as
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?
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
pgsql-general by date
|Next:||From: Sergei Chernev||Date: 1998-12-10 05:09:13|
|Subject: libpg++ documentation|
|Previous:||From: Marcin Grondecki||Date: 1998-12-09 05:15:09|
|Subject: AIX 4.1 & plpgsql|