Search Postgresql Archives

Re: Modifying SQL parser with extensions?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux