Postgres Pro
Downloads
Home   >   mailing lists

Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values
Date
Msg-id 2961345.1673017109@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: Resolve iso-8859-1 type to relevant type instead of text type while bulk update using values
List pgsql-hackers
Tree view 
Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> writes:
> we cast a quoted value to UNKNOWN type, but this is a special value
> null which can be casted to any SQL data type. Probably we could add a
> ANYNULLTYPE or some such generic null type which can be casted to any
> data type. Then a null value without any type is labeled as
> ANYNULLTYPE if specific type information is not available.

And ... how does that differ from the existing behavior of UNKNOWN?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: Optimizing Node Files Support
Next
From: Tom Lane
Date:
Subject: Re: Optimizing Node Files Support