Re: Modifying SQL parser with extensions?

From: Richard Troy <rtroy(at)ScienceTools(dot)com>
To: Matthias Lüdtke <matthias-luedtke(at)gmx(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Modifying SQL parser with extensions?
Date: 2006-10-29 17:45:49
Message-ID: Pine.LNX.4.33.0610290943130.30114-100000@denzel.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Matthias,

what you want might be a type of collation sequence. You should be able to
code that within Postgres, I'd think, but I wouldn't think that passing
arguments as comments is appropriate.

RT

On Sun, 29 Oct 2006, Matthias Lüdtke wrote:

> Date: Sun, 29 Oct 2006 18:26:30 +0100
> From: Matthias Lüdtke <matthias-luedtke(at)gmx(dot)de>
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Modifying SQL parser with extensions?
>
>
> Richard Troy wrote:
> > Our package lets you pass individual statements or entire files full
> > of SQL with embeded comments as it's not that uncommon among SQL
> > dialects - they're just stripped out before getting to the engine, as
> > Alvaro suggested.
>
> Unfortunately I need the information in the statement to sort the result
> set in a certain way later on. Sorry, I should have mentioned that from
> the beginning.
>
> This whole thing I want to implement was already written as a proxy JDBC
> driver - from parser to result sorter - and works quite fine. I am now
> investigating if it's possible to implement it directly in an RDBMS,
> i.e. PostgreSQL.
>
> Regards,
> Matthias
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy(at)ScienceTools(dot)com, http://ScienceTools.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-29 17:49:56 Re: Modifying SQL parser with extensions?
Previous Message Tom Lane 2006-10-29 17:42:08 Re: Adding a column