Re: Old question - failed to find conversion function from

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: dev(at)archonet(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Old question - failed to find conversion function from
Date: 2005-07-19 17:24:27
Message-ID: 42DD374B.000003.26351@mfront8.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

>Richard Huxton <dev(at)archonet(dot)com> writes:
>> [* Actually, I think NULLs are typed in SQL, which means you should be
>> able to get type violations. ]
>
>I'm pretty sure the entire construct is illegal per a strict reading of
>the SQL spec --- the spec only allows NULL to appear in contexts where a
>datatype can be assigned to it immediately.

Honestly I cannot say this info changes too much for me (other DBMSs I use as backend handle this untyped NULLs), though the situation is clarified.

Thanks a lot.

--
Best regards
Ilja Golshtein

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dirk Lutzebäck 2005-07-19 17:48:59 Re: dump/restore needed when switching from 32bit to 64bit
Previous Message Guido Barosio 2005-07-19 16:49:30 Re: how to load a .backup file

Browse pgsql-general by date

  From Date Subject
Next Message Josef Springer 2005-07-19 17:26:30 How to pass the password for login in psql
Previous Message vinita bansal 2005-07-19 16:45:15 RAMFS with Postgres