Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: >> In Postgres 17 trying to create the function yields an error: >> >> pg17> create function json_test(out value text, out json jsonb) >> returns record >> ... >> ERROR: syntax error at or near "jsonb" >> LINE 1: create function json_test(out value text, out json jsonb) >> >> Am I doing something wrong? Or is this a regression? > Yes you are doing something wrong, naming an argument with a type > name(json) is not a good idea. The actual problem is that the SQL standards committee invented some bizarre syntax that we couldn't parse without making JSON a partially-reserved word. It still works as a type name, but in this particular syntax where it's not initially clear which names are type names, you lose. Double-quote the argument name, or name it something other than "json". regards, tom lane
