Re: Implicit coercions need to be reined in

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Thomas Lockhart" <lockhart(at)fourpalms(dot)org>
Cc: "Barry Lind" <barry(at)xythos(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Implicit coercions need to be reined in
Date: 2002-04-16 18:51:33
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961DB0@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> The lines marked XXX are the ones that I enabled since yesterday, and
> would like to disable again:
>
> implicit | result | input | prosrc
> ----------+-------------+-------------+--------------------------------------

> no | varchar | int8 | int8_text

Wow, I am completely at a loss why you would not allow implicit coercions
that do not loose any data in the process.
Coercing an int to float would in some cases loose precision. It is thus imho
debateable what to do here, but not for the rest.

I would think it a major step in the wrong direction.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-04-16 19:12:52 Re: [PATCHES] [SQL] 16 parameter limit
Previous Message Zeugswetter Andreas SB SD 2002-04-16 18:38:08 Re: Implicit coercions need to be reined in