Re: [HACKERS] GSoC 2017: Foreign Key Arrays

Поиск
Список
Период
Сортировка
От Mark Rofail
Тема Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Дата
Msg-id CAJvoCus+tNubBvdApMFcEEYA6PxLaUwLSK6frb=Dn=2y-bnEiw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] GSoC 2017: Foreign Key Arrays  (Mark Rofail <markm.rofail@gmail.com>)
Ответы Re: [HACKERS] GSoC 2017: Foreign Key Arrays  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Jul 12, 2017 at 2:30 PM, Mark Rofail <markm.rofail@gmail.com> wrote:
On Wed, Jul 12, 2017 at 12:53 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
We have one opclass for each type combination -- int4 to int2, int4 to
int4, int4 to int8, etc.  You just need to add the new strategy to all
the opclasses.
 
Can you clarify this solution ? I think another solution would be external casting 

If external casting is to be used. If for example the two types in question are smallint and integer. Would a function get_common_type(Oid leftopr, Oid rightopr) be useful ?, that given the two types return the "common" type between the two in this case integer.

Best Regards,
 Mark Rofail

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: [HACKERS] bug in locking an update tuple chain
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [HACKERS] SCRAM auth and Pgpool-II