Re: Duda sobre como imprimir un campo INTERVAL

2022-11-19 Thread Tom Lane
Ken Tanzer writes: > Thanks. I could understand that they're not identical. But then what's > going on where Postgres evaluates them as equal? (i1=i2 above.) Are the > two intervals getting cast or converted to something else before they are > compared, with whatever makes them non-identical

Re: Duda sobre como imprimir un campo INTERVAL

2022-11-19 Thread Ken Tanzer
On Sat, Nov 19, 2022 at 2:39 AM Alban Hertroys wrote: > > > > don't fully understand it. But what really confuses me is the example > below. How can these two intervals be equal and still yield different > output in the to_char function? And as a practical matter, and for the OPs > question, h

RES: RES: session_user different from current_user after normal login

2022-11-19 Thread Murillo corvino rocha
Could it be the role=group_read_only? The fact that user1 is a member of group_read_only is changing current_user variable? I’m using a clean psql docker container everytime I need to connect to the database, so, I don’t think it’s related to psql. \drds List of settings R

Re: Duda sobre como imprimir un campo INTERVAL

2022-11-19 Thread Alban Hertroys
> On 19 Nov 2022, at 4:58, Ken Tanzer wrote: > > On Thu, Nov 17, 2022 at 2:30 PM Alejandro Baeza Rangel > wrote: (…) > don't fully understand it. But what really confuses me is the example below. > How can these two intervals be equal and still yield different output in the > to_char fu

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-19 Thread Peter J. Holzer
On 2022-11-18 16:21:18 -0600, Ron wrote: > On 11/18/22 16:13, Peter J. Holzer wrote: > > So you can give these credentials to you developers or devops folks > > (whom you trust not attack the system - > > They like to "fix" things without documenting what they did, and then, when > something break