Re: [Fwd: Re: SQL99 Hierarchical queries]

On Sun, May 15, 2005 at 04:44:57PM +0800, Christopher Kings-Lynne wrote:
> Looks like hierarchical queries are now officially stalled :(
>
> Anyone want to take this up for 8.1?

Sergei and Jason,

Feel like taking SQL:1999 WITH RECURSIVE? It would be a giant help to
the PostgreSQL community. :)

http://gppl.moonbone.ru/index.shtml

has part of it, and

http://candle.pha.pa.us/mhonarc/patches2/msg00175.html

has others.

There's also MERGE, which is covered starting on page 47 of
http://wiscorp.com/sql/SQL2003Features.pdf

also pp 839-845 of 5WD-02-Foundation-2003-09.pdf which is part of
this:
http://wiscorp.com/sql/sql_2003_standard.zip

and an overview here:
http://www.varlena.com/varlena/GeneralBits/73.php

Cheers,
D
> Hi,
>
> I haven't done any significant progress on that way because of lack of
> free time.
> Beside this, I'm recently changed my job and now I'm woking for MySQL.
> I think it's not possible for me to continue work on PostgreSQL.
> Feel free to take the patch and develop it further as long as you
> mention me as author of initial version.
>
> Regards, Evgen.
>
> On 5/5/05, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> wrote:
> >Hi Evgen,
> >
> >I just keep pinging this patch thread every once in a while to make sure
> >it doesn't get forgotten :)
> >
> >How is the syncing with 8.1 CVS coming along?
> >
> >Chris
> >
> >Evgen Potemkin wrote:
> >> Hi hackers!
> >>
> >> I have done initial implementation of SQL99 WITH clause (attached).
> >> It's now only for v7.3.4 and haven't a lot of checks and restrictions.
> >> It can execute only simple WITH queries like
> >> WITH tree AS (SELECT id,pnt,name,1::int AS level FROM t WHERE id=0
> >> UNION SELECT t.id,t.pnt,t.name,tree.level+1 FROM t JOIN tree ON
> >> tree.id=t.pnt ) SELECT * FROM tree;
> >> It would be great if someone with knowledge of Pg internals can make a
> >> kind of code review and make some advices how to better implement all
> >> this.
> >>
> >> Regards, Evgen.
> >>
> >>
> >> ------------------------------------------------------------------------
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 3: if posting/reading through Usenet, please send an appropriate
> >> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >> message can get through to the mailing list cleanly
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

On Wed, May 11, 2005 at 07:01:50PM -0700, Sergey Ten wrote:
> Hello all,
>
> We would like to contribute to the Postgresql community by implementing
> the following items from the TODO list
> (http://developer.postgresql.org/todo.php):
> . Allow COPY to understand \x as a hex byte . Allow COPY to optionally
> include column headings in the first line . Add XML output to COPY
>
> The changes are straightforward and include implementation of the
> features as well as modification of the regression tests and documentation.
>
> Before sending a diff file with the changes, we would like to know if
> these features have been already implemented.
>
> Best regards,
> Jason Lucas and Sergey Ten
> SourceLabs
>
> Dependable Open Source Systems
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!