query syntax change?

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема query syntax change?
Дата
Msg-id 3B45EE6A.332F566D@austin.rr.com
обсуждение исходный текст
Ответы Re: query syntax change?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
This query works in 7.0.3...

SELECT p.*, e.id AS "employee_id", e.ref_name,
       e.business_line_id, e.record_status_id AS "emp_record_status_id"
FROM person p, employee e
WHERE e.person_id = p.id

UNION ALL

SELECT p.*, NULL AS "employee_id", NULL AS "ref_name",
       NULL AS "business_line_id", NULL AS "emp_record_status_id"
FROM person p
WHERE NOT EXISTS (SELECT id FROM employee WHERE person_id = p.id)
ORDER BY p.sortable_last_name;

but in 7.1.2 it reports the following error:

    ERROR:  Relation 'p' does not exist

Anyone understand why?

Regards,
Ed Loehr

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

Предыдущее
От: "Ian Harding"
Дата:
Сообщение: Re: pgsql and sql-relay
Следующее
От: "Richard Huxton"
Дата:
Сообщение: Re: Vacuum and Transactions