Received: from photon.skillbrokers.bg (root@[195.24.42.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA38631; Mon, 6 Dec 1999 10:18:48 -0500 (EST) (envelope-from nmmm@nmmm.nu) Received: from niki (proton.skillbrokers.bg [195.24.42.206]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id RAA26992; Mon, 6 Dec 1999 17:10:25 +0200 Message-ID: <002001bf3ffd$17309980$ce2a18c3@skillbrokers.bg> From: "Nikolay Mijaylov" To: "pgsql-general" , Subject: Fw: Whats happen here? Date: Mon, 6 Dec 1999 17:17:59 +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 > > > > root=> select * from x a, y b where text(a.a) = text(b.b); >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; > >