Hello,
MySQL 4.1 and Oracle 10g do the cast automatically, so I think the
behavior should be changed if the SQL standards require it in this case.
In general, it is confusing for programmers that 'years' has type
unknown, 0 is integer, 0.5 is numeric, true is boolean, etc.
Also I can imagine th
"Thomas" <[EMAIL PROTECTED]> writes:
> select * from (select 'years' as recurrence) p where recurrence = 'years'
> it gives:
> ERROR: failed to find conversion function from "unknown" to text
Try casting the unknown value to some specific type, eg
regression=# select * from (select 'years'::text
The following bug has been logged online:
Bug reference: 3259
Logged by: Thomas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.1
Operating system: WinXP SP2
Description:Problem with automatic string cast
Details:
I have this SQL:
select * from (select 'ye
