Received: from photon.skillbrokers.bg (root@[195.24.42.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA37752; Mon, 6 Dec 1999 10:13:50 -0500 (EST) (envelope-from nmmm@webfactory.bg) Received: from niki (proton.skillbrokers.bg [195.24.42.206]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id RAA26841; Mon, 6 Dec 1999 17:05:23 +0200 Message-ID: <000501bf3ffc$638f2fe0$ce2a18c3@skillbrokers.bg> From: "Nikolay Mijaylov" To: "pgsql-general" , , Subject: Whats happen here? Date: Mon, 6 Dec 1999 17:13:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Whats happen here? ------------------------- root=> \dt Database = root +------------------+----------------------------------+----------+ | Owner | Relation | Type | +------------------+----------------------------------+----------+ | root | x | table | | root | y | table | +------------------+----------------------------------+----------+ root=> \d x Table = x +----------------------------------+----------------------------------+----- --+ | Field | Type | Length| +----------------------------------+----------------------------------+----- --+ | a | char() | 20 | +----------------------------------+----------------------------------+----- --+ root=> \d y Table = y +----------------------------------+----------------------------------+----- --+ | Field | Type | Length| +----------------------------------+----------------------------------+----- --+ | a | varchar() | 5 | +----------------------------------+----------------------------------+----- --+ root=>select * from x a, y b where a.a = b.a; ERROR: There is more than one possible operator '=' for types 'bpchar' and 'varchar' You will have to retype this query using an explicit cast -------------------------------------------------------------- The reboots are for hardware upgrades! "http://www.nmmm.nu;