由买买提看人间百态

topics

全部话题 - 话题: tupleid
(共0页)
c*****t
发帖数: 1879
1
来自主题: Database版 - PostgreSQL question
I have several tables with identical schema:
tupleId int unique,
data bytea
I am writing some server procedures that trys to lookup
a tuple using (tableOid, tupleId) pair. The reason to
break down the tables are to make indexing easier (data
is indexed using custom functions).
What's the efficient way of getting Datnum that represents
the tuple? Most of the time I have 1 tuple to retrieve,
but there also times that I have a bunch.
I could get the Relation using RelationIdGetRelation (
(共0页)