UPDATE, JOIN and RETURNING ?

[TeddyLourson]

Hi, I have this simple PostgreSQL database :

CREATE TABLE file_info(
  id UUID PRIMARY KEY UNIQUE NOT NULL,
  name TEXT NOT NULL,
  extension TEXT NOT NULL,
  path TEXT NOT NULL,
  bucket TEXT NOT NULL,
  kind TEXT NOT NULL,
  file_metadata JSONB,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ
);
CREATE TABLE account(
  id UUID PRIMARY KEY UNIQUE NOT NULL,
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ
);
CREATE TABLE profile(
  id UUID PRIMARY KEY UNIQUE NOT NULL,
  username TEXT NOT NULL,
  bio TEXT,
  code TEXT,
  image_id UUID REFERENCES file_info(id),
  age_restriction INTEGER,
  synced_theme_id TEXT,
  account_id UUID NOT NULL REFERENCES account(id),
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ
);

I would like to :

• update the profile
• join the id and path of the file_info table
• return the updatedProfile row and the id and path of file_info.

I figured out the updating the profile part but I can't get the join part on the file_info table working.

Here's a snippet of what I tried without any luck :

// Failure n°1 :
row, err := models.Profiles.UpdateQ(ctx, bTx,
	h.buildColumnsToUpdate(profileUpdate),
	models.UpdateJoins.Profiles.LeftJoin.ImageFileInfo(ctx),
	um.Returning("*"),
).One()

// Failure n°2 :
updateQuery := models.Profiles.UpdateQ(ctx, bTx,
	h.buildColumnsToUpdate(profileUpdate),
	models.UpdateJoins.Profiles.LeftJoin.ImageFileInfo(ctx),
	um.Returning("*"),
)
models.UpdateJoins.Profiles.LeftJoin.ImageFileInfo(ctx).Apply(updateQuery.Expression)
row, err := updateQuery.One()