ERROR: SELECT DISTINCT ON with postgresql v 7.1.2

Поиск
Список
Период
Сортировка
От Kelbert
Тема ERROR: SELECT DISTINCT ON with postgresql v 7.1.2
Дата
Msg-id 9j3i40$2hof$1@news.tht.net
обсуждение исходный текст
Ответы Re: ERROR: SELECT DISTINCT ON with postgresql v 7.1.2  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Hello,

I have a problem white one sql request. I got this error message :

Warning: PostgreSQL query failed: ERROR: SELECT DISTINCT ON expressions
must match initial ORDER BY expressions in
/export/castor-b7/local-home/kelbertj/Prog/web/lumiere/admin/recherche_realisateurs.php
on line 85 ERROR: SELECT DISTINCT ON expressions must match initial
ORDER BY expressions SELECT DISTINCT ON (people_id)
people_id,people_lastname,people_firstname from people where
lower(people_firstname) ~* (SELECT text_accents('\\\"Luc\\$')) order by
people_lastname ASC limit 40 offset 0

I didn't find any solution to this problem ! If you have any idea I'll
be most gratefull If you could answer !

Thanks

--
Jean-Michel KELBERT


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jean-Michel Kelbert
Дата:
Сообщение: ERROR: SELECT DISTINCT ON with postgresql v 7.1.2
Следующее
От: Gunnar Rønning
Дата:
Сообщение: Re: Re: Idea: recycle WAL segments, don't delete/recreate 'em