Re: Patch: Add parse_type Function - Mailing list pgsql-hackers

From Jim Jones
Subject Re: Patch: Add parse_type Function
Date
Msg-id dbed3b98-3d86-41e4-bded-b15016f122dc@uni-muenster.de
Whole thread Raw
In response to Re: Patch: Add parse_type Function  (Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>)
Responses Re: Patch: Add parse_type Function
List pgsql-hackers
On 05.02.24 15:32, Dagfinn Ilmari Mannsåker wrote:
> Once the function is declared strict, I don't think either of these is
> necessary: function strictness is tested elsewhere, and it's the default
> behaviour.  The only functions that explicitly say they return NULL on
> NULL inputs are quote_literal (because you might expect it to return the
> string 'NULL', but there's qoute_nullable for that) and xmlexists (which
> I don't see any particular reason for).
>
> - ilmari
>
>
+1
Yes, if the function was strict (which in the current design is not the
case) there is no need to check for nulls.

-- 
Jim




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: cataloguing NOT NULL constraints
Next
From: "David G. Johnston"
Date:
Subject: Re: Grant read-only access to exactly one database amongst many