Re: "Relation does not exist" error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Relation does not exist" error
Дата
Msg-id 16793.1005230078@sss.pgh.pa.us
обсуждение исходный текст
Ответ на "Relation does not exist" error  (Tuckheng <Tuckheng@vads.com>)
Список pgsql-general
Tuckheng <Tuckheng@vads.com> writes:
> I encountered this error when trying to run a SELECT statement from within a
> Perl program. Would appreciate if someone could help shed some light on what
> may be causing this or how it can be resolved.

ORDER BY on a UNION result can only refer to column names of the UNION
output columns.  Lose the "p." and "s." in the ORDER BY and you'll be
fine.

            regards, tom lane

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

Предыдущее
От: t.ngockhoi@bpf.vnu.com
Дата:
Сообщение: Réf. : OID's as Primary Keys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: OID's as Primary Keys