I understand, I've read the source code of analyze.c and implemented a java version.
Stakind1(most common values) indicates "=" operator and stakind2(histogram) indicates "<" operator by default,
I'm wondering where I can find the corresponding operatorID of eq/lt for a specific data type.
For example,
"=" operator for the type "varchar" is "texteq" and "<" operator for varchar is "text_lt"
"=" operator for the type "int4" is "int4eq" and "<" operator for int4 is "int4lt" etc.
And another question is that how to update or insert a column with type of "anyarray", since I want to mock the statistic data of tables, the type of stavalues in pg_statistic is anyarray, is there any way to manually modify that column, by some kind of function or hook?
If I ran the query like:
UPDATE pg_statistic
SET stavalues2=array[1,2,8]
WHERE ...
Then I will get error 42804 indicates that the expected type is anyarry but text[] is found in the query.
Thanks very much!