Re: [SQL] Looking for information on PostgreSQL Stored Procedures - Mailing list pgsql-general

From Tom Lane
Subject Re: [SQL] Looking for information on PostgreSQL Stored Procedures
Date
Msg-id 17602.1134324486@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Looking for information on PostgreSQL Stored Procedures  ("Foster, Stephen" <stephenlfoster@comcast.net>)
List pgsql-general
"Foster, Stephen" <stephenlfoster@comcast.net> writes:
>     WHILE (--Lost on variable name for end of query;
> EmptyQueryResponse <> 0? --)

    WHILE FOUND
    LOOP
        ...
    END LOOP

Although as Michael mentioned, this is all the hard way; any experienced
plpgsql programmer would forget the cursor entirely and just write a
FOR-loop.

            regards, tom lane

pgsql-general by date:

Previous
From: "Foster, Stephen"
Date:
Subject: Re: [SQL] Looking for information on PostgreSQL Stored Procedures
Next
From: stig erikson
Date:
Subject: using more then one CPU for queries