Re: [HACKERS] 9.0b1: "ERROR: btree index keys must be ordered by attribute"

[Ian Barwick]

2010/5/10 Ian Barwick <barw...@gmail.com>:
> SELECT ov.object_id
>    FROM object_version ov
>   WHERE ov.object_id = 1
>     AND ov.version ='0
>     AND ov.object_status_id = (
>     SELECT MAX(ov1.object_status_id)
>       FROM object_version ov1
>      WHERE ov1.object_id=ov.object_id
>        AND ov1.version = ov.version
>        AND ov1.lang = ov.lang
>       )
>     AND ov.lang = 'en';

Apologies, slight c&p error; correct version of query:

SELECT ov.object_id
   FROM object_version ov
  WHERE ov.object_id = 1
    AND ov.version =0
    AND ov.object_status_id = (
    SELECT MAX(ov1.object_status_id)
      FROM object_version ov1
     WHERE ov1.object_id=ov.object_id
       AND ov1.version = ov.version
       AND ov1.lang = ov.lang
      )
    AND ov.lang = 'en';

FWIW the test case works fine in 8.4.3


Ian Barwick

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers