Re: Function not running after upgrade 7.03 to 7.2

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Function not running after upgrade 7.03 to 7.2
Дата
Msg-id GNELIHDDFBOCMGBFGEFOMEMECCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Function not running after upgrade 7.03 to 7.2  (juerg.rietmann@pup.ch)
Список pgsql-sql
> Query :
>
> SELECT *,
> (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang
> FROM zylinder;
>
> Thank's in advance for any help .... jr

Try this:

SELECT *,
(SELECT rtrim("buildUmfang"(zylinder.z_typ), ','::text) AS rtrim) AS umfang
FROM zylinder;

I think it's because you have an upper case letter in the name - you might
need to quote it.

Chris



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

Предыдущее
От: juerg.rietmann@pup.ch
Дата:
Сообщение: Function not running after upgrade 7.03 to 7.2
Следующее
От: Wei Weng
Дата:
Сообщение: ON DELETE CASCADE question