DDL Clause in Index Specification and Partial Index for Posgresql

How To
, ,
1

What for is the DDL Clause in Index Specification?
Is it possible to create Partial Index in ERD diagram for Posgresql?https://www.postgresql.org/docs/8.0/indexes-partial.html

2

Hi Jerzy,

DDL Clause is a custom string that will be appended to the end of the create index statement. You can specify “where …” to create partial index.

Best regards,
Jick Yeung

3

This DDL clause appears in meany forms.
I guess, it always appended to VP generated SQL ?
Am I right?

4

Hi Jerzy,

Yes, the DDL clause entered will append to the DDL generated.

Best regards,
Jick Yeung