You are right, I also found the same behaviour when using e.g the UNIX sed
command.
Ingolf
On Mon, Aug 23, 2021 at 4:24 PM Francisco Olarte
wrote:
> Ingolf:
>
> On Mon, Aug 23, 2021 at 2:39 PM Markhof, Ingolf
> wrote:
> > Yes, When I use (\1)? instead of (\1)+, the expre
olf Markhof
International Network Product - International Access <
inp-intlacc...@verizon.com>
Sebrathweg 20, 44149 Dortmund, Germany
Office: +49 231 972 1475 | Vnet: 317-1475
On Fri, Aug 20, 2021 at 6:11 PM Markhof, Ingolf <
ingolf.mark...@de.verizon.com> wrote:
> Hi Tom,
p_replace(
string_agg(descr,',' order by len_mm),
'([^,]+)(,\1)?($|,)',
'\1\3',
'g'
)
from vu_items;
Thx again for your hint in the regexp_replacy issue in my other post...
Regards,
Ingolf
On Thu, Aug 19, 2021 at 6:30 PM Tom Lane wrote:
> &q
consume all a's in a sequence in one go,
just like "a+" does...?!
Regards,
Ingolf
On Fri, Aug 20, 2021 at 6:52 PM Tom Lane wrote:
> "Markhof, Ingolf" writes:
> > thank you very much for your reply. Actually, I was assuming all these
> > regular express
Thank you very much for all your proposals!
Ingolf
==
Verizon Deutschland GmbH - Sebrathweg 20, 44149 Dortmund, Germany - Amtsgericht
Dortmund, HRB 14952 - Geschäftsführer: Detlef Eppig - Vorsitzender des
Aufsichtsrats: France
nstead of (\1)+, the
expression is evaluates quickly!
Thank you very much for looking into this and for proposing the alternative
approach which is working fine.
Regards
Ingolf
On Fri, Aug 20, 2021 at 12:42 AM Tom Lane wrote:
> "Markhof, Ingolf" writes:
> > BRIEF:
> > re
I am looking for something like
string_agg(distinct col_x order by col_y)
Unfortunately, you can either have the distinct, but then the order by
needs to be identical to what's aggregated, or you can have the order be
determined by another column. Not both...
Here is the playground
Given:
crea
BRIEF:
regexp_replace(source,pattern,replacement,flags) needs very (!) long to
complete or does not complete at all (?!) for big input strings (a few k
characters). (Oracle SQL completes the same in a few ms)
VERBOSE
Given a comma-separated list of "words" (whereas a word is any sequence of
char
Hi!
I recently switched from Oracle SQL to PostgreSQL.
In Oracle, I can easily delete a table or view that is used by existing
views. The system marks the affected views. I can then re-define the
deleted table or view and have all dependent views easily re-compiled. Done.
PostgreSQL instead is p
t to the execution time.
I don't really understand why execution 16*50 takes 16*2 secs only, but
executing 1*800 takes about 3000 seconds...
Regards,
Ingolf
-Original Message-
From: Sebastian Dressler [mailto:sebast...@swarm64.com]
Sent: 30 January 2021 11:45
To: Markhof, Ingolf
Hi!
I am struggling with the slow performance when running queries referring to
foreign tables. - Yes, I know... - Please read the whole story!
The set-up basically is a production database and a reporting database. As
names indicate, the production database is used for production, the reportin
Hi!
Today, I made an astonishing / disappointing experience related to that source
code topic:
You may not be able to delete tables / views that are referenced by other users
objects,
e.g. views. Unless you add the CASCADE option which will cause all depending
views to be
deleted as well. And
Tom, all,
when I change a tables column name in Oracle SQL , SQLdeveloper (a SQL client)
marks views that refer to the table using the old column name as erroneous. So,
I can easily identify these cases. And of course I, as a user, I am acting in
my context, i.e. my schema. So it is perfectly c
Thanks for your comments and thoughts.
I am really surprised that PostgreSQL is unable to keep the source text of a
view. Honestly, for me the looks like an implementation gap. Consider software
development. You are writing code in C++ maybe on a UNIX host. And whenever you
feed you source code
So, it looks like PostgreSQL does support saving the original source code of a
view.
What's best practise to use as a code repository?
I would expect support of multi-user access, access-right management and
perhaps versioning as well…?
Thanks for your help!
Ingolf
From: Markhof, I
Hi!
Switching from Oracle SLQ to PostgreSQL I am facing the issue that the SQL code
the system returns when I open a views source code is different from the code I
entered. The code is formatted differently, comments are gone and e.g. all text
constants got an explicit cast to ::text added. (se
16 matches
Mail list logo
