PL/pgsql function handle CUBE values

Поиск
Список
Период
Сортировка
От Rajarshi Guha
Тема PL/pgsql function handle CUBE values
Дата
Msg-id F9DD3928-CDB6-4B32-9D32-E35EA6228AD1@indiana.edu
обсуждение исходный текст
Ответы Re: PL/pgsql function handle CUBE values  (Colin Wetherbee <cww@denterprises.org>)
Список pgsql-general
Hi, I am trying to write a PL/pgsql function that will take a CUBE
variable (which will be a 1D point) and a double precision variable.

If the input CUBE is defined as

'(x,y,z)'::cube

the function would then return a CUBE value of the form

'(x+R,y+R,z+R),(x-R,y-R,z-R)'::cube

where R is the second argument.

The problem I'm having is to actually add R to the individual
components of the CUBE variable. I can't cast CUBE to float[] and I
don't see anyway to get at the individual components of the CUBE.

Any pointers would be appreciated.

-------------------------------------------------------------------
Rajarshi Guha  <rguha@indiana.edu>
GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04  06F7 1BB9 E634 9B87 56EE
-------------------------------------------------------------------
"355/113 -- Not the famous irrational number PI,
but an incredible simulation!"



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

Предыдущее
От: "Webb Sprague"
Дата:
Сообщение: SVN event hooks for PL/PGSQL functions and DDL?
Следующее
От: Colin Wetherbee
Дата:
Сообщение: Re: PL/pgsql function handle CUBE values