Postgres Pro
Downloads
Home   >   mailing lists

Re: PG-Sample | Error | Equality operator for type json - Mailing list pgsql-general

From Abhinav Mehta
Subject Re: PG-Sample | Error | Equality operator for type json
Date
Msg-id DC5CFA5C-1F4A-4BF1-9233-58E81BF49B3E@metarain.com
Whole thread Raw
In response to PG-Sample | Error | Equality operator for type json  (Abhinav Mehta <abhinav@metarain.com>)
List pgsql-general
Tree view
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@metarain.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

pgsql-general by date:

Previous
From: Abhinav Mehta
Date:
Subject: PG-Sample | Error | Equality operator for type json
Next
From: Tom Lane
Date:
Subject: Re: How to split an array into columns