Re: Precision loss casting float to numeric - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Precision loss casting float to numeric
Date
Msg-id 6147.1519674945@sss.pgh.pa.us
Whole thread Raw
In response to Re: Precision loss casting float to numeric  (Chapman Flack <chap@anastigmatix.net>)
Responses Re: Precision loss casting float to numeric  (Emre Hasegeli <emre@hasegeli.com>)
List pgsql-hackers
Chapman Flack <chap@anastigmatix.net> writes:
> I wonder if an alternative to making a cast that can't be immutable,
> because it looks at a GUC, could be to offer a choice of cast
> functions: if you need the other behavior, create a schema, do a
> CREATE CAST in it, and put it on your search path ahead of pg_catalog.

Nope, because casts aren't schema-local, since they don't have names.
There can be only one cast between given source and target types.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid memory alloc request size error with commit 4b93f579
Next
From: Bear Giles
Date:
Subject: Re: Precision loss casting float to numeric