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_
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
On Jan 18, 2007, at 2:38 AM, Jan Meyland Andersen wrote:
But the problem here is that the where-clause depends on the
relkind. That
is why I'm trying to solve the problem this way.
I think that clause can be written as a subselect and added to the
expression. Or just make that a separate
