Thanks David
Worked like a charm and results are correct
Armand
On Apr 4, 2017, at 5:00 PM, David G. Johnston
wrote:
> On Tue, Apr 4, 2017 at 2:51 PM, Armand Pirvu (home)
> wrote:
>
> But if I join back to foo1 like below I get
>
> select a.audit_id, a.table_name, b[1],b[2]
> from
> fo
On Tue, Apr 4, 2017 at 2:51 PM, Armand Pirvu (home)
wrote:
>
> But if I join back to foo1 like below I get
>
> select a.audit_id, a.table_name, b[1],b[2]
> from
> foo1 a,
> (select
> array(
> select
> column_name::text from
> information_schema.columns
> where
> table_name=a.table_name
> and
> (
