| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |