Whats happen here?

From: "Nikolay Mijaylov" <nmmm(at)webfactory(dot)bg>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>, <pgsql-sql(at)postgreSQL(dot)org>, <pgsql-error(at)postgreSQL(dot)org>
Subject: Whats happen here?
Date: 1999-12-06 15:13:00
Message-ID: 000501bf3ffc$638f2fe0$ce2a18c3@skillbrokers.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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; <nmmm(at)nmmm(dot)nu>

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Mijaylov 1999-12-06 15:17:59 Fw: Whats happen here?
Previous Message vincent leycuras 1999-12-06 13:44:37 java and postgres

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-12-06 15:14:02 Re: [SQL] Wierd stuff
Previous Message Assaf Gottlieb 1999-12-06 13:55:41 OLE-DB vs. ODBC performance on SQL Server 7.0: