Обсуждение: Understanding 8.4 new WITH syntax
I've seen a few examples about 8.4 Implementation of WITH syntax. However, I don't fully understand how the various parts of this kind of query work together as a whole. Does anyone know of any good resources that explain it well? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
On Wed, Oct 8, 2008 at 4:31 PM, Richard Broersma <richard.broersma@gmail.com> wrote:
I've seen a few examples about 8.4 Implementation of WITH syntax.
However, I don't fully understand how the various parts of this kind
of query work together as a whole. Does anyone know of any good
resources that explain it well?
is the way to go.
Try writing some stuff, to understand it. Otherwise you can read as much as you wish.
Also, you can try to read our colleague's blog:
I see some proposal for implementing FOR loop for cursor in PG 8.4, but I could not found documentaion on how to loop or iterate thru a cursor in PG 8.3 or earler versions?
I guess I could do a FOR loop if I know the size of a cursor? How to find the size of a cursor?
Thanks,
CYW
<cyw@dls.net> writes:
> I see some proposal for implementing FOR loop for cursor in PG 8.4, but I could not found documentaion on how to loop
oriterate thru a cursor in PG 8.3 or earler versions?
LOOP
FETCH ...;
EXIT WHEN NOT FOUND;
...
END LOOP;
regards, tom lane