Re: forgive the test....please no flames!!!

From: Gary Eckhardt <gary_eckhardt_at_realworld.com>
Date: 1996/09/24
Message-ID: <324851BC.3FCE_at_realworld.com>#1/1

David Pettit wrote:

>

> select *
> from table
> where primary_key > :last_retrieved_pk and
> order by primary_key

No, no, no, no. You should never put your primary on the table. It should be in a dark place, preferrably cool.

Try this:

    select *
    from chest_freezer
    where primary_key = "HEFEWEISEN" and

          o_g = "1.062"
    order by primary_key;

<running and ducking before the crowd starts throwing hydrometers>

---------------------------+----------------------------------------------
Gary Eckhardt              |   "in this day & age...music performed by
Database Consultants, Inc. |    humans...hum!?"  --wilde silas tomkyn
dcigary_at_txdirect.net       |                R,DW,HAHB!

gary_eckhardt_at_realworld.com| R^3 = "Real World. Real Smart. Real Quick."
(210)344-6566 | http://www.realworld.com/ Received on Tue Sep 24 1996 - 00:00:00 CEST