Re: Psql regex is NFA or DFA? - Mailing list pgsql-general

From Tom Lane
Subject Re: Psql regex is NFA or DFA?
Date
Msg-id 19291.1031667213@sss.pgh.pa.us
Whole thread Raw
In response to Psql regex is NFA or DFA?  (Josh Jore <josh@greentechnologist.org>)
Responses Re: Psql regex is NFA or DFA?
List pgsql-general
Josh Jore <josh@greentechnologist.org> writes:
> So I've finished reading Jeffery Friedl's _Mastering Regular Expressions_
> and while I don't need regex in PostgreSQL I know I'll do it for something
> - eventually. The book makes a distinction between DFA, POSIX NFA and
> Traditional NFA and then ascribes some properties and behaviours to each.
> So what sort does PostgreSQL have?

Well, you could read the code (src/backend/regex), or you could apply
the tests that Friedl suggests to distinguish the type of an unknown
engine ...

My guess is that it's an NFA, but I dunno if Spencer did the POSIX
semantics or not.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: nextval result type difference between 7.1.3 and 7.2.1
Next
From: "v.nrg"
Date:
Subject: statement triggers