Thread: urgent: problems with query_limit

Hi

We upgraded our system from 6.4 to the new 6.5 version. The set query_limit function is not working
anymore in 6.5.

db => set query_limit to '100';
SET VARIABLE
db => select * from table;

statement is returning all records from the table. What's wrong here?

Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hello experts.

 I am writing my first function using the SPI_ interface.

 I don't know how to access data that I just selected.

 here's the outline:

 my question is in the block comments

 thanks a ton!!!!

 mike



int32 allocate_address(int32 networkID)
{
    char[255]  query;

    if (SPI_connect() < 0) {
       return 0;
    }

    sprintf(query,
            "Select addressID FROM networkaddress WHERE networkid = %i",
            networkID);

    if (SPI_exec(query, 1) < 0) {
       return 0;
    }

    /* ############################################################ */
    /* how do I access the data that I just selected ?               */
    /* ie I want to find the value of the each row in the select
    /* ############################################################ */

    SPI_finish();

    return 1;
}
~

On Wed, 30 Jun 1999, Herbert Liechti wrote:

> We upgraded our system from 6.4 to the new 6.5 version. The set query_limit function is not working
> anymore in 6.5.
>
> db => set query_limit to '100';
> SET VARIABLE
> db => select * from table;
>
> statement is returning all records from the table. What's wrong here?

Whereas I'm not sure right now about what's wrong there, you should check
the new documentation of the SELECT command for the LIMIT specifier, as in
select * from table limit 100;
That might help.

--
Peter Eisentraut
PathWay Computing

> Hi
>
> We upgraded our system from 6.4 to the new 6.5 version. The set query_limit function is not working
> anymore in 6.5.
>
> db => set query_limit to '100';
> SET VARIABLE
> db => select * from table;
>
> statement is returning all records from the table. What's wrong here?
>

Use the new LIMIT syntax on a SELECT query.  It will be removed in the
upcoming 6.5.1.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026