| Subject | Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-02-28T19:27:30Z |
On 28-2-2019 02:02, Robert Tulloch tultalk@... [firebird-support]
wrote:
This means: use the literal value 'MEMPAY1' under the column name
TABLE_NAME and output it for each row (and similar for INDEX_NAME). In
other words, no matter the content, each row will have the value 'MEMPAY1'.
If you want to filter on table and index name, you need to add a
condition in the WHERE clause, so:
where RDB$RELATION_NAME = 'MEMPAY1'
and RDB$INDEX_NAME = 'M1ID1'
and (RDB$SYSTEM_FLAG is null or RDB$SYSTEM_FLAG = 0)
Mark
--
Mark Rotteveel
wrote:
> Hi:select 'MEMPAY1' AS TABLE_NAME
>
> I just ran this
>
> select 'MEMPAY1' AS TABLE_NAME, 'M1ID' AS INDEX_NAME,
> cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS from rdb$indices
> where RDB$SYSTEM_FLAG is null
> or RDB$SYSTEM_FLAG = 0 order by RDB$STATISTICS
>
> And it returned 76 "records" all the same table and index but with
> different values for RDB$STATISTICS
>
> ranging from 0.0001628664467716590 to 1.000000000000000
>
> Over my head. How can there be 76 different values?
This means: use the literal value 'MEMPAY1' under the column name
TABLE_NAME and output it for each row (and similar for INDEX_NAME). In
other words, no matter the content, each row will have the value 'MEMPAY1'.
If you want to filter on table and index name, you need to add a
condition in the WHERE clause, so:
where RDB$RELATION_NAME = 'MEMPAY1'
and RDB$INDEX_NAME = 'M1ID1'
and (RDB$SYSTEM_FLAG is null or RDB$SYSTEM_FLAG = 0)
Mark
--
Mark Rotteveel