Re: set role command

2025-11-28 Thread Peter J. Holzer
On 2025-11-24 17:30:14 -0500, [email protected] wrote: > Just because you did set role does not mean you lost your superuser > privileges, > it's correct behavior. > > If you want to impersonate in a permissions sandbox it's easy: > > create role usera_sandbox in group usera; > \c - usera_san

Re: Selecting all variations of job title in a list

2025-11-28 Thread Jacqui Caren
Many years ago I used a weak precedence engine to categorize this form of job title script to a job code. The regexp did not work because we had asst to gen mgr The wpe tokenized the words then relaxed token patterns with other token codes with cumulative context The final token reduction resulted

Re: Selecting all variations of job title in a list

2025-11-28 Thread Bernice Southey
Rich Shepard wrote: > Learning postgres regexp is at the top of my list. It's well worth knowing a few regex tricks and they're surprisingly easy to remember. I find these the most useful for ad hoc queries. '|' for or as mentioned '()' if you want to check part of an expression eg '(abc|xyz)pqr