Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Sayyid Ali Sajjad Rizavi <sasrizavi(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values
Date: 2023-01-06 14:58:29
Message-ID: 2961345.1673017109@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-01-06 15:18:03 Re: Optimizing Node Files Support
Previous Message Ranier Vilela 2023-01-06 14:49:34 Re: Optimizing Node Files Support