Re: Display oprcode and its volatility in \do+ - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Display oprcode and its volatility in \do+
Date
Msg-id 27409.1389887059@sss.pgh.pa.us
Whole thread Raw
In response to Re: Display oprcode and its volatility in \do+  (Marko Tiikkaja <marko@joh.to>)
Responses Re: Display oprcode and its volatility in \do+  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Marko Tiikkaja <marko@joh.to> writes:
> On 1/16/14 4:22 PM, Tom Lane wrote:
>> FWIW, I'm on board with the idea of printing the oprcode, but adding
>> volatility here seems like probably a waste of valuable terminal width.
>> I think that the vast majority of operators have immutable or at worst
>> stable underlying functions, so this doesn't seem like the first bit
>> of information I'd need about the underlying function.

> Completely unscientifically, 50% of the time I've wanted to know the 
> oprcode has been because I wanted to know its volatility (exactly 
> because of the stable oprcodes we have).  It seemed like a useful 
> addition, but I don't feel that strongly about it.

Hm.  Personally, I've lost count of the number of times I've had to
resort to "select ... from pg_operator" because \do lacked an oprcode
column, but I don't remember that many or indeed any were because
I wanted to check the volatility.

Anybody else have an opinion?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: WAL Rate Limiting
Next
From: Heikki Linnakangas
Date:
Subject: Re: WAL Rate Limiting