A couple of pgsql questions

Поиск
Список
Период
Сортировка
От Jack V Chung
Тема A couple of pgsql questions
Дата
Msg-id 200010181648.MAA14350@nerd-xing.mit.edu
обсуждение исходный текст
Ответы Re: A couple of pgsql questions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello,

I want to apologize in advance if I sent this to the wrong mailing list.

I'm was trying out the example functions using TCL, but for function
was not created.  Here's the error:


db=# CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS '
    if {$1 > $2} {return $1}
    return $2
' LANGUAGE 'pltcl';
db'# physionetdb'# physionetdb'# ERROR:  Unrecognized language specified in
    a CREATE FUNCTION: 'pltcl'.  Recognized languages are sql, C, internal
    and the created procedural languages.


Here is my current version:


db=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66




I used the RPM to installed all the files including
postgresql-tk-7.0.2-2.i386.rp and postgresql-tcl-7.0.2-2.i386.rpm

Can someone assist me?




Another question, can someone point me to documentation that explains how
to wrap a few insert statments in a transaction?


thanks a lot
jack

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: OID and joins
Следующее
От: Adam Haberlach
Дата:
Сообщение: Re: OID and joins