Re: Can Postgres beat Oracle for regexp_count?

2022-02-03 Thread Shaozhong SHI
limited explanation on ?:. Is it correct to say that this ?: construction of a regex can be applied for checking whether cell values meet specifications? Regards, David On Thu, 3 Feb 2022 at 05:59, Tom Lane wrote: > Shaozhong SHI writes: > > The following has been attempted but n

Re: Can Postgres beat Oracle for regexp_count?

2022-02-03 Thread Shaozhong SHI
Hi, David, Many thanks. I am investigating into transformation of data quality validation through automation with application of Postgres/PostGIS. Regards, David On Thu, 3 Feb 2022 at 13:00, David G. Johnston wrote: > > > On Thursday, February 3, 2022, Shaozhong SHI > wrote: &

Re: Regular Expression For Duplicate Words

2022-02-03 Thread Shaozhong SHI
Hi, Peter, Interesting. On Thu, 3 Feb 2022 at 19:48, Peter J. Holzer wrote: > On 2022-02-02 08:00:00 +0000, Shaozhong SHI wrote: > > regex - Regular Expression For Duplicate Words - Stack Overflow > > > > Is there any example in Postgres? > > It's pretty mu

Turn a json column into a table

2022-02-14 Thread Shaozhong SHI
There is a JSON column in a table. It contains key value pairs, just like a dictionary. What is the best way to turn this column into a data table? Regards, David

Operator % and its meaning and use

2022-02-15 Thread Shaozhong SHI
Can anyone remind me of the meaning and use of operator %. It works in one of scripts like WHERE NOT (street_name % designatedname) Regards, David

Is there a way to automatically scan a table and determine the format of data

2022-02-15 Thread Shaozhong SHI
Is there a way to automatically scan a table and report the format of data for each column? Regards, David

frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity

2022-02-17 Thread Shaozhong SHI
How to calculate frequency of positive and negative numbers and define and calculate frequency of alteration of polarity? Surely, we can use frequency of alteration of polarity and level of change (e.g., size of positive and negative numbers) to measure degree and frequency of alteration. Any ide

Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity

2022-02-17 Thread Shaozhong SHI
On Thursday, 17 February 2022, Thomas Munro wrote: > On Fri, Feb 18, 2022 at 9:11 AM Shaozhong SHI > wrote: > > How to calculate frequency of positive and negative numbers and define > and calculate frequency of alteration of polarity? > > > > Surely, we can use

Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity

2022-02-17 Thread Shaozhong SHI
On Thu, 17 Feb 2022 at 21:20, Thomas Munro wrote: > On Fri, Feb 18, 2022 at 9:11 AM Shaozhong SHI > wrote: > > How to calculate frequency of positive and negative numbers and define > and calculate frequency of alteration of polarity? > > > > Surely, we can use

<    1   2