Thanks for correcting me, will definitely study citext and see how a new type is registered in plugin.
2018-05-24 23:23 GMT-07:00 Aleksandr Parfenov <a.parfe...@postgrespro.ru>: > On Thu, 24 May 2018 18:25:28 -0700 > Charles Cui <charles.cui1...@gmail.com> wrote: > > The second is to provide thrift type just like json or jsonb. When you > > create a table, postgres knows ::thrift keywords. > > I think method one should be easier to implement because it only > > limits to this plugin. Method two needs modify postgres kernel to > > register a new type, which may time consuming, > > but more natural. Any ideas on this? > > > > Thanks, Charles > > Hi Charles, > > I prefer the second way with separate type. But I think it is good idea > to wait for an answer from your project mentor or someone other. > > I'm not an expert in PostgreSQL user-defined types, but AFAIK, it > doesn't require changes in PostgreSQL core, since types can be created > in extensions. It doesn't require changes to grammar or something. > You can look at citext contrib as an example. > > -- > Aleksandr Parfenov > Postgres Professional: http://www.postgrespro.com > Russian Postgres Company >
