Returning bigint from C extension

Поиск
Список
Период
Сортировка
От Jason Armstrong
Тема Returning bigint from C extension
Дата
Msg-id f51cd3b20911222358h27a98894xb2770e8dd2a669e3@mail.gmail.com
обсуждение исходный текст
Ответы Re: Returning bigint from C extension
Список pgsql-general
How can I return a bigint value from a C extension function?

I have a table with a bytea column:

CREATE TABLE mydata(data bytea);

I would like to select and index based on a subset of the data:

CREATE FUNCTION get_key(bytea) returns BIGINT AS '/lib/data.so'
LANGUAGE C IMMUTABLE;
CREATE INDEX mydata_key_idx on mydata(get_key(data));

# SELECT get_key(data) FROM mydata;

My code :

PG_FUNCTION_INFO_V1(get_key);
Datum get_key(PG_FUNCTION_ARGS)
{
  bytea *val;
  unsigned int len;
  long long res;

  val = PG_GETARG_BYTEA_P(0);
  len = VARSIZE(val) - VARHDRSZ;
  res = _extract_key(VARDATA(val), len);
  PG_FREE_IF_COPY(val, 0);

  PG_RETURN_INT32(res);
}

The PG_RETURN_INT32() macro causes the server to terminate.

It works if I convert to a cstring:

  char *result = palloc(32);
  snprintf(result, 32, "%lld", res);
  PG_RETURN_CSTRING(result);

But then I can't index it, or sort on it either.

(And, as a side note, is the above code the correct way to use bytea
data from C?)

Regards,

--
Jason Armstrong

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

Предыдущее
От: "Pinter Bernd"
Дата:
Сообщение: Re: Is there a tool used to display statement times from postgres logs
Следующее
От: Alexandra Roy
Дата:
Сообщение: Re: DBD::Pg 2.15.1 compilation failed