postgres C++ functions

Поиск
Список
Период
Сортировка
От Vladimir V. Zolotych
Тема postgres C++ functions
Дата
Msg-id 0475.001004@eurocom.od.ua
обсуждение исходный текст
Список pgsql-admin
Hello all,

Please help me with
create function days_in_month(int4, int4, int4) returns int4
as '/tmp/days.so' language 'c';

Can I write this function days_in_month in C++ ?
I've did the following:

extern "C" {
int days_in_month(int year, int mo, int day);
}

extern "C" {
int days_in_month(int year, int mo, int day) {
═══ return 13;
}
}

Compile with
  $ g++ -I/usr/local/qt/include -o days.so -shared days.cpp

then (as user postgres)
  my=> create function days_in_month(int4, int4, int4) returns int4
  my=> as '/tmp/days.so' language 'c';
  CREATE

I've tried to use new function
  my=> select days_in_month(3, 3, 3);
  ERROR:═ Can't find function days_in_month in file /tmp/days.so
  my=>

What is wrong ?
I'm using postgres 6.4 under RedHat.
Any help will be appreciated.

--
Best regards,
 Vladimir                          mailto:gsmith@eurocom.od.ua



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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Foreign key
Следующее
От: Cristóvão Dalla Costa
Дата:
Сообщение: bug found in the dump/restore process