Re: Help with SQL

2018-05-27 Thread Rob Sargent
> On May 27, 2018, at 6:42 PM, anand086 wrote: > > Hi, > > I have a requirement of writing plpgsql function to create partial indexes > on child tables if it exists on parent table. The function will have > schemname, childtablename, tableowner as input. > > I am using the below code to ident

Help with SQL

2018-05-27 Thread anand086
Hi, I have a requirement of writing plpgsql function to create partial indexes on child tables if it exists on parent table. The function will have schemname, childtablename, tableowner as input. I am using the below code to identify the indexname and index definition from parent table -- ``` wi