RE: [HACKERS] Recursive queries? - Mailing list pgsql-hackers

From Zeugswetter Andreas SARZ
Subject RE: [HACKERS] Recursive queries?
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A51EC@sdexcsrv1.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> In POSTQUEL this is written like this (note I'm not sure about correct
> POSTQUEL syntax):
>
> retrieve into ancestor(p.x,p.y) from p in parent
>
> retrieve* into ancestor(a.x,p.y) from a in ancestor, p in parent where
> a.y=p.x.
>
> You see the second line generates new tuples every time it's executed
> until there is no more data deductable.

This sounds really interesting, I have been puzzeling on how to resolve the
CNAME points
to another CNAME ... which finally points to an IP address for our name
resolution
admin database. This would be it !

Andreas

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Here it is - view permissions
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: pl/{perl,pgsql} (was Re: AW: [HACKERS] triggers, views and rules (not instead))