ERROR: using an explicit cast
| От | Wim Ceulemans | 
|---|---|
| Тема | ERROR: using an explicit cast | 
| Дата | |
| Msg-id | 003201be237e$e87c3c20$67faa8c0@aladdin.nice.be обсуждение исходный текст  | 
		
| Список | 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.ceulemans@nice.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 по дате отправления: