Re: [HACKERS] Recursive SQL

2005-04-03 Thread Euler Taveira de Oliveira
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 pat

[HACKERS] Recursive SQL

2005-04-03 Thread Ioannis Theoharis
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 wit

Re: [HACKERS] recursive SQL

2004-07-01 Thread Potemkin Evgen
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,

Re: [HACKERS] recursive SQL

2004-07-01 Thread Andrew Overholt
* 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

Re: [HACKERS] recursive SQL

2004-06-30 Thread Michael Meskes
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 othe

Re: [HACKERS] recursive SQL

2004-06-30 Thread jacob koehler (RRes-Roth)
> -Original Message- > From: Andrew Overholt [mailto:[EMAIL PROTECTED] > Sent: 28 June 2004 16:45 > To: jacob koehler (RRes-Roth) > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Alexander Rüegg > Subject: Re: recursive SQL > > > * jacob koehler (RRes-Roth) <[EMAIL PROTECTED]> > [2004-06-2

Re: [HACKERS] recursive SQL

2004-06-29 Thread Hannu Krosing
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 wo

Re: [HACKERS] recursive SQL

2004-06-29 Thread Christopher Kings-Lynne
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 be great if patch will be included in postgres, and if it needed sure i will relicense it to BSD.

Re: [HACKERS] recursive SQL

2004-06-29 Thread jacob koehler (RRes-Roth)
, 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 > >

Re: [HACKERS] recursive SQL

2004-06-26 Thread Tom Lane
"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 recu

Re: [HACKERS] recursive SQL

2004-06-26 Thread Christopher Kings-Lynne
- 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 an

Re: [HACKERS] recursive SQL

2004-06-26 Thread jacob koehler (RRes-Roth)
> -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 wonder

Re: [HACKERS] recursive SQL

2004-06-26 Thread Andrew Dunstan
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 b

[HACKERS] recursive SQL

2004-06-26 Thread jacob koehler (RRes-Roth)
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/ cons: - its not standard SQL (uses oracle style syntax) pros: - it would add a feature that many people miss already for ages. all existing workarou

Re: [HACKERS] Recursive SQL functions

2001-10-13 Thread Tom Lane
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 entr

[HACKERS] Recursive SQL functions

2001-10-13 Thread Peter Eisentraut
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