Skip site navigation (1) Skip section navigation (2)

ERROR: using an explicit cast

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 (view raw or flat)
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




Responses

pgsql-general by date

Next:From: Sergei ChernevDate: 1998-12-10 05:09:13
Subject: libpg++ documentation
Previous:From: Marcin GrondeckiDate: 1998-12-09 05:15:09
Subject: AIX 4.1 & plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group