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

Re: [GENERAL] ERROR: using an explicit cast

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: <pgsql-general(at)postgresql(dot)org>, "Wim Ceulemans" <wim(dot)ceulemans(at)nice(dot)be>
Subject: Re: [GENERAL] ERROR: using an explicit cast
Date: 1998-12-10 13:45:39
Message-ID: 19615.981210@bo.nettuno.it (view raw or flat)
Thread:
Lists: pgsql-general
Hello Wim,

mercoledì, 9 dicembre 98, you wrote:

WC> Hi all

WC> I am using postgres 6.3.2 and I experience problems using a union on views
WC> In short, I have the following views defined:

WC> create view vstockpart as select 'StockPart' as vpisource, pspid as
WC> vpisourceid;
WC> create view vquoteoutitem as select 'QuoteOutItem' as vpisource, fqoiid as
WC> vpisourceid;

WC> where pspid and fqoiid are both of type int.

WC> When I launch the following query:

WC> select vpisource,vpisourceid from vstockpart union select
WC> vpisource,vpisourceid from vquoteoutitem;

WC> then I get the following error:

WC> NOTICE:    there is no more then one operator < for types
WC> NOTICE:    unknown and unknown. You will have to retype this query
WC> ERROR:    using an explicit cast.

WC> Where can I find documentation regarding casts?
WC> Does anybody know what is wrong? Or do I have to move to 6.4?

WC> TIA
WC> Wim Ceulemans - wim(dot)ceulemans(at)nice(dot)be
WC> Nice Software Solutions
WC> Eglegemweg 3, 2811 Hombeek - Belgium
WC> Tel +32(0)15 41 29 53 - Fax +32(0)15 41 29 54


   CREATE VIEW vista AS SELECT 'Hello World'

          View will be created having a column with an unknown type
          unless you specify it as:

   CREATE VIEW vista AS SELECT 'Hello World'::text


   -Jose'-



In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 1998-12-10 17:15:00
Subject: Re: [GENERAL] TODO list elements
Previous:From: Laurent DELVAUXDate: 1998-12-10 10:21:07
Subject:

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