Re: Modifying SQL parser with extensions?

Matthias Lüdtke wrote:
> Alvaro Herrera wrote:
> >>I am searching for the easiest way to let PostgreSQL parse a special
> >>dialect of SQL. The dialect I want to parse augments common SQL in a way
> >>that enables expressions within a WHERE clause to be annotated and is
> >>thus not compatible with the standard SQL syntax anymore.
> >
> >No, there's no mechanism for that. You'd have to preprocess the query
> >before passing it to PostgreSQL.
>
> Actually I didn't describe my whole story:
>
> In fact, parsing this SQL dialect would just be the first step, as the
> annotations within the query induce an ordering of the result set.

Huh, what is this supposed to be able to do that you can't do with the
already existing ORDER BY clause?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support