Can someone politely explain this craziness?
INSERT INTO "dbo"."UserProfile" ("FirstName")
VALUES('John')
RETURNING "UserProfileId" INTO _UserProfileId;
throws an ambiguous reference error, however this correctly executes:
INSERT INTO "dbo"."UserProfile" ("FirstName")
VALUES('John')
RETURNING "dbo"."UserProfile"."UserProfileId" INTO _UserProfileId;
_UserProfileId
is a declared integer variable. I couldn't find any references to this syntax in the manual or why on earth this would be ambiguous in any way.