int2[] vs int2vector in pg_catalog?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема int2[] vs int2vector in pg_catalog?
Дата
Msg-id Pine.LNX.4.58.0403290933130.2084@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответы Re: int2[] vs int2vector in pg_catalog?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Dear hackers,

I'm wondering for the rationnal of the types used in various tables in
pg_catalog (v 7.4.2) so as to represent the very same thing:

- in pg_index, the indkey is represented by a int2vector

- in pg_constraint, conkey and confkey are represented my smallint[]

As I was trying to compare the two, I have to resort to some hacks.

It also appears that there are very few available function to deal with
int2vector at the SQL or PL/pgSQL level. Basically I found none:-(

Any comments?

-- 
Fabien Coelho - coelho@cri.ensmp.fr


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fuzzy cost comparison to eliminate redundant planning
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: [GENERAL] PG vs MySQL (fwd)