From: | "Ilja Golshtein" <ilejn(at)yandex(dot)ru> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Old question - failed to find conversion function from "unknown" |
Date: | 2005-07-19 09:50:06 |
Message-ID: | 42DCCCCE.000006.04382@mfront8.yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi!
I've already asked this question a month ago -
it remains unanswered.
Dare to repeat since this issue is rather important for me.
So.
When I invoke
select 1 where 5 in (null)
everything is Ok,
though when I try
select 1 where 5 in (select null)
I get
ERROR: failed to find conversion function from "unknown" to integer.
Is it desired behavior or subject to change
in future versions of PG?
I realize my simplified example looks radiculous while it came from reality.
Sometimes my engine generates SQL queries does not know correct type
and unable to cast, while PostgreSQL should have all information required.
Thanks.
--
Best regards
Ilja Golshtein
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-07-19 11:03:35 | Re: Old question - failed to find conversion function from |
Previous Message | Dirk Lutzebäck | 2005-07-19 09:03:37 | dump/restore needed when switching from 32bit to 64bit processor architecture? |
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Bjorklund | 2005-07-19 10:42:20 | Re: index row size exceeds btree maximum, 2713 - Solutions? |
Previous Message | Martijn van Oosterhout | 2005-07-19 09:48:16 | Re: Converting MySQL tinyint to PostgreSQL |