Re: PG-Sample | Error | Equality operator for type json

From: Abhinav Mehta <abhinav(at)metarain(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PG-Sample | Error | Equality operator for type json
Date: 2018-08-24 13:07:06
Message-ID: DC5CFA5C-1F4A-4BF1-9233-58E81BF49B3E@metarain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

BTW - I’ve tried figuring out myself and understood UNION workaround could help, but since it’s via pg-sample so just want to understand if there a quick workaround without tweaking pg-sample itself.

> On 24-Aug-2018, at 6:20 PM, Abhinav Mehta <abhinav(at)metarain(dot)com> wrote:
>
> Hi Team,
>
> I’m getting running into following issue while executing pg-sample
>
> Error
> ====
> DBD::Pg::db do failed: ERROR: could not identify an equality operator for type json
> LINE 3: SELECT DISTINCT t1.*
> ^ at ./pg_sample line 296.
> main::__ANON__("DBD::Pg::db do failed: ERROR: could not identify an equality"..., DBI::db=HASH(0x1704258), undef) called at ./pg_sample line 638
> /pg_sample$ ./pg_sample mydb | psql sampledb
> ====
>
> Executing Command
> ====
> pg_sample mydb | psql sampledb
> ====
> —
> Thanks
> Abhinav

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-08-24 13:41:04 Re: How to split an array into columns
Previous Message Abhinav Mehta 2018-08-24 12:50:37 PG-Sample | Error | Equality operator for type json