Bug?
От | Martín Marqués |
---|---|
Тема | Bug? |
Дата | |
Msg-id | 0108102058540B.15878@bugs обсуждение исходный текст |
Ответы |
Re: Bug?
|
Список | pgsql-hackers |
What's wrong with this query that used to work great: webunl=> SELECT DISTINCT count(*),id_curso AS LINK,titulo AS TITULO_CARRERA,admin_view_facultades.nombre AS FACULTAD, webunl-> duracion/12 AS DURACION FROM admin_view, admin_view_facultades webunl-> WHERE admin_view_facultades.id_carrera=admin_view.id_curso webunl-> GROUP BY id_curso,titulo,admin_view_facultades.nombre,duracion/12 webunl-> ORDER BY id_curso ASC LIMIT 20 OFFSET 0 ;count | link | titulo_carrera | facultad | duracion -------+------+-----------------------------+--------------------------------+---------- 1 | 1 | Ingenieria en informatica | Facultad de Ingenier<ED>a Qu<ED>mica | 4 1 | 2 | Licenciatura en Matematicas | Facultad de Ingenier<ED>a Qu<ED>mica | 4 (2 rows) webunl=> As you can see count(*) is 1, even seeing 2 rows selected. What's wrong? All that chenged is that I recompiled postgreSQL 7.1.2 with the patch from the rewriteHandler.c file. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------
В списке pgsql-hackers по дате отправления: