Ivan Radovanovic writes:
Thanks Adrian, but question was how to decide which types are indexable
A little bit of research in the system-catalogs documentation will show
you how to find the types that can be accepted by some index opclass
(hint: "pg_opclass.opcintype::regtype").

As far as the other question goes, you could look for types that have a
pg_type.typmodin function -- though I'm not sure whether you want to
consider every possible usage of typmods as being a "precision".

    regards, tom lane

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 13 of 17 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedAug 14, '13 at 12:17p
activeAug 15, '13 at 3:49p
posts17
users7
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2018 Grokbase