| From: | Jean-Michel Kelbert <jean-michel(at)club-internet(dot)fr> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | ERROR: SELECT DISTINCT ON with postgresql v 7.1.2 |
| Date: | 2001-07-18 08:36:42 |
| Message-ID: | 20010718103642.C26025@castor.obs.coe.int |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kelbert | 2001-07-18 08:40:57 | ERROR: SELECT DISTINCT ON with postgresql v 7.1.2 |
| Previous Message | jerome crouigneau | 2001-07-18 08:25:34 | Memory management |