12.12.2018 19:26, Robert Tulloch tultalk@... [firebird-support] wrote:

Not using firebird at all.

   In this case you are in wrong support list.

Hi:

  Never mind the dll/udf

Statement:

SELECT cast (RDB$RELATION_NAME as varchar(32)) AS TABLE_NAME,cast (RDB$INDEX_NAME as varchar(32)) AS INDEX_NAME, RDB$STATISTICS from rdb$indices  WHERE rdb$system_flag = 0 order by RDB$STATISTICS


rdb$system_flag is 0 for user defind indexes and 1 and greater for system indexes.

If I code WHERE 0 = 0 order by RDB$STATISTICS

I get everything in result set but with WHERE rdb$system_flag = 0 I get nothing.

Why would that be since rdb$system_flag should return 0 or 1
Thanks from out lander.

Robert