Also i'd like to answer you if postgresQL has implemented rcursive queries
proposed from SQL99 standard?
If yes, are there any restrictions of the model on your implementation?
---(end of broadcast)---
TIP 2: you can get off all lists at once
Hi Ioannis,
Also i'd like to answer you if postgresQL has implemented rcursive
queries
proposed from SQL99 standard?
Not yet. But there is a patch around that implement it. See
http://gppl.moonbone.ru/
If yes, are there any restrictions of the model on your
implementation?
The patch the
* jacob koehler (RRes-Roth) [EMAIL PROTECTED] [2004-06-27 20:58]:
cons:
- its not standard SQL (uses oracle style syntax)
Besides the GPL issue, this is my biggest problem.
i am aware of the fact that tom lane pointed to the fact that Andrew
Overholt did work towards SQL99 compliant
ok, i'll fix some nasty bugs, and post it here for review.
regards,
evgen
-Original Message-
On Tue, Jun 29, 2004 at 07:23:45PM +0800, Christopher Kings-Lynne wrote:
I'm a PostgreSQL developer and I would like to see an SQL99 recursive
queries feature in PostgreSQL.
Me too, on bot
On Tue, Jun 29, 2004 at 07:23:45PM +0800, Christopher Kings-Lynne wrote:
I'm a PostgreSQL developer and I would like to see an SQL99 recursive
queries feature in PostgreSQL.
Me too, on bot parts.
I'm not a committer myself, so I think I should explain how things work.
We're unlike other
, and some friendly words might encourage him to do the
required work.
cheers,
jacob
-Original Message-
From: Potemkin Evgen [mailto:[EMAIL PROTECTED]
Sent: 28 June 2004 16:05
To: jacob koehler (RRes-Roth)
Subject: Re: FW: [HACKERS] recursive SQL
Hello,
yes, it would
[mailto:[EMAIL PROTECTED]
Sent: 28 June 2004 16:05
To: jacob koehler (RRes-Roth)
Subject: Re: FW: [HACKERS] recursive SQL
Hello,
yes, it would be great if patch will be included in postgres,
and if it needed sure i will relicense it to BSD. problem is
that core team don't want to include
On T, 2004-06-29 at 13:11, jacob koehler (RRes-Roth) wrote:
seems evgen has got a sql99 compliant version of recursive SQL
out and would agree to relicense it.
are there any other concerns regarding evgens work? or do you want to
encourage him to go this route? i have the impression he would
jacob koehler (RRes-Roth) wrote:
hi,
i am wondering what you think about including evgen potemkin's patch for recursive SQL
in the next postgres version:
http://gppl.terminal.ru/
[snip]
- Evgen DID publish this patch under GPL, see:
http://gppl.terminal.ru/README.html
It would first have to
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: 26 June 2004 20:42
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] recursive SQL
jacob koehler (RRes-Roth) wrote:
hi,
i am wondering what you think about including evgen potemkin's patch
- Evgen DID publish this patch under GPL, see:
http://gppl.terminal.ru/README.html
We cannot use GPL code in PostgreSQL. PostgreSQL is BSD licensed. As
to why on earth he GPL'd - I have no idea...
Chris
---(end of broadcast)---
TIP 1: subscribe
jacob koehler (RRes-Roth) [EMAIL PROTECTED] writes:
It would first have to be relicensed ...
it would be interesting to know if it would be included, IFF the author
publishes it under BSD.
This patch has been proposed and rejected before. It doesn't do the
SQL-standard syntax for recursion,
While looking to implement the ODBC replace() function (replace occurences
of $2 in $1 by $3), I found that it could be expressed as:
CREATE FUNCTION replace(text, text, text) RETURNS text AS '
select
case when position($2 in $1) = 0 or char_length($2) = 0
then $1
Peter Eisentraut [EMAIL PROTECTED] writes:
I was wondering whether, as a future project, we could make this more
convenient by parsing the body of the function with the binding of the
function already in effect.
Seems like a simple rearrangement of the code. First insert the pg_proc
entry,
14 matches
Mail list logo