🚀 go-pugleaf

My problem is simple but I can't find a solution. I have a table with a 
primary integer key set by a generator.

The next field is a name field, say customer name. I want to return records 
10 to 19 of the customer table sorted alphabetically by customer name. The 
natural order of the records is the generated customer id number which is 
the order in which the records were inserted. I assume that select first 10 
skip 10 * Order By Customer_Name will select the second 20 records in their 
insert order THEN sort the result vy Customer Name. However, what I want is 
to presort the records alpabetically on customer name and THEN select the 
second 20 records.

In other words, I if I enter the following records A1, A2, A3, A4, A5, A6, 
A7, B1, B2, B3, B4, B5, B6, B7, C1, C2, C3, C4, C5, ......Zn then I enter 
B8, the natural storage order is that order. I want the result set to 
include B8 as part of the second set of 10 records.

I think the solution is to create and index on customer name and use PLAN to 
select, (PLAN (Customers INDEX (IDX1)),  however, I always get a message 
saying that there is no table or alias named IDX1.

What is the correct solution?

Mark Horrocks