pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ilja Golshtein <ilejn@yandex.ru>
To: pgsql-general@postgresql.org
Subject: Old question - failed to find conversion function from "unknown"
Date: Tue, 19 Jul 2005 13:50:06 +0400 (MSD)
Message-ID: <42DCCCCE.000006.04382@mfront8.yandex.ru> (raw)
In-Reply-To: <42DCC1E9.2060300@aeccom.com>
References: <42DCC1E9.2060300@aeccom.com>

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



view thread (8+ messages)  latest in thread

Message-ID: <42DCCCCE.000006.04382@mfront8.yandex.ru>
Permalink:  ../42DCCCCE.000006.04382@mfront8.yandex.ru/
Also on:    postgresql.org/message-id/42DCCCCE.000006.04382@mfront8.yandex.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: ilejn@yandex.ru, pgsql-general@postgresql.org
  Subject: Re: Old question - failed to find conversion function from "unknown"
  In-Reply-To: <42DCCCCE.000006.04382@mfront8.yandex.ru>
  References: <42DCC1E9.2060300@aeccom.com> <42DCCCCE.000006.04382@mfront8.yandex.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox