Re: versions

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Re: versions
Дата
Msg-id 3DE5198B.4020005@mega-bucks.co.jp
обсуждение исходный текст
Ответ на versions  ("Al Bean" <albean84@hotmail.com>)
Список pgsql-general
Al Bean wrote:
>
> mytestdb-# select current_timestamp;
> ERROR:  parser: parse error at or near "select"

Are you sure? Try it again. I think you made a typo the first time. SQL
is not case sensitive (at least not in this case). "select
current_timestamp;" works fine for me.

> mytestdb=# create function test1() returns integer as 'begin return 1;
> end;' language 'plpgsql';
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
>        Pre-installed languages are SQL, C, and internal.
>        Additional languages may be installed using 'createlang'.

The error message is self-explanatory.

use from the command line:

# createlang plpgsql mytestdb

Jc


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

Предыдущее
От: Felipe Schnack
Дата:
Сообщение: table name size
Следующее
От: Medi Montaseri
Дата:
Сообщение: How was my PG compiled