| From: | Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
|---|---|
| To: | "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
| Subject: | RE: [HACKERS] Recursive queries? |
| Date: | 1998-02-23 08:43:59 |
| Message-ID: | 219F68D65015D011A8E000006F8590C6010A51EC@sdexcsrv1.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1998-02-23 09:41:12 | Re: pl/{perl, pgsql} (was Re: AW: [HACKERS] triggers, views and rules (not instead)) |
| Previous Message | Jan Wieck | 1998-02-23 08:28:29 | Re: [HACKERS] Here it is - view permissions |