Re: [SQL] Help ... Unexpected results when using limit/offset with

2007-01-18 Thread Stephan Szabo
On Thu, 18 Jan 2007, Barbara Cosentino wrote: > Then I perform the following selects > > SELECT host_id, host_datum_type_id, host_datum_source_id, data > FROM nc_host_datum INNER JOIN nc_host USING (host_id) > WHERE audit_id=2041 > ORDER BY host_id > LIMIT 49 OFFSET 1372; > > And > > SELECT host_

[SQL] Help ... Unexpected results when using limit/offset with select statement..DB corruption?

2007-01-18 Thread Barbara Cosentino
I got some weird results when processing select statements with limit and offset. I think its some kind of database corruption but I was wondering what other's think. Background: The table I'm having the issue with is described below. The thing to note is the primary key ice=# \d nc_host