Facing issues with JOIN operation.

[tusharmalpani20]

I am using PostgreSQL 14 on (WSL2 : Ubuntu) and have installed your extension using deb files which @pksunkara have provided here.

Here are my table schema.

CREATE TABLE IF NOT EXISTS "project_schema"."project"(
    "id" ulid NOT NULL DEFAULT gen_ulid() PRIMARY KEY,
    "name" VARCHAR(255) NOT NULL
);

CREATE TABLE IF NOT EXISTS "demo_schema"."demo" (
    "id" ulid NOT NULL DEFAULT gen_ulid() PRIMARY KEY,
    "name" varchar(255) DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS "demo_schema"."demo_project" (
    "demo_id" ulid NOT NULL REFERENCES "demo_schema"."demo"(id),
    "project_id" ulid NOT NULL REFERENCES "project_schema"."project"(id)
);

When I want to run a join function to get all the demo for a particular project, I am using the following query

SELECT * FROM demo_schema.demo JOIN demo_schema.demo_project ON demo.id= demo_project.demo_id WHERE demo_project.project_id  = '01H9FS1KBXDKAH9GNEGNMNDYW4';

I encounter the following error :

ERROR:  could not find commutator for operator 17239
SQL state: XX000

Can you please help me find a solution for the above.

[pksunkara]

This has been fixed in 0.1.2