Re: syntax error at or near "PERFORM"

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: syntax error at or near "PERFORM"
Дата
Msg-id 48A5E9C0.9070505@iol.ie
обсуждение исходный текст
Ответ на Re: syntax error at or near "PERFORM"  (Dale <harris_da@yahoo.com.au>)
Список pgsql-general
On 15/08/2008 05:32, Dale wrote:
> On Aug 15, 2:14 pm, Dale <harris...@yahoo.com.au> wrote:
<snip>
>> even when I try executing something basic:  PERFORM (2 + 3);
<snip>
> I found my problem.  Unfortunately PERFORM can only be used within a
> "LANGUAGE plpgsql" script.

Yes, that's it - outside a function, you just do:

   select (2 + 3);

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [Q] DNS(bind) ER model
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: plpgsql functions