Selecting a Range of Rows

[ghaleon]

I was curious if you might know how I would do a range of rows in PSQL starting at row 10 with a limit of 20 rows.

In MYSQL it would just be select * from table limit 10, 20

Thanks in advance.

 

[TomKane]

Hi,

Have you thought about using the tranasctional (ISAM) engine in Pervasive. It's a bit technical but you'll be able to do pretty much whatever you want AND it will be very fast!

Regards,
Tom

 

[ghaleon]

I have no idea what that is or how to do it

 

[TomKane]

Hi,

Take a look at this.

http://www.pervasive.com/developerzone/access_methods/btrieve.asp

Regards,
Tom