Horton

Re: [HACKERS] Standards question

Roland Roberts <roberts@panix.com>

View thread
From: Roland Roberts <roberts@panix.com>
To: PostgreSQL Hacker <pgsql-hackers@postgreSQL.org>
Date: 1998-08-05T02:00:09Z
Lists: pgsql-hackers 
>>>>> "Thomas" == Thomas G Lockhart <lockhart@alumni.caltech.edu> writes:

    >> i=1; 
    >> exec sql declare C cursor for select name from table where nr=:i; 
    >> i=2; 
    >> exec sql open C; Which row will be selected?

    Thomas> Things should evaluate at the "open".
    [...]

This is also how it works with Oracle.

roland
-- 
Roland B. Roberts, PhD                  Custom Software Solutions
roberts@panix.com                           101 West 15th St #4NN
                                               New York, NY 10011