@@ -281,7 +281,7 @@ NOTICE: r1.q1 = <NULL>
281281NOTICE: r1.q2 = <NULL>
282282NOTICE: r1 = <NULL>
283283ERROR: record "r1" has no field "nosuchfield"
284- CONTEXT: PL/pgSQL expression "r1.nosuchfield"
284+ CONTEXT: SQL expression "r1.nosuchfield"
285285PL/iSQL function inline_code_block line 7 at RAISE
286286-- records, not so much
287287do $$
@@ -295,7 +295,7 @@ end$$;
295295NOTICE: r1 = <NULL>
296296ERROR: record "r1" is not assigned yet
297297DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.
298- CONTEXT: PL/pgSQL expression "r1.f1"
298+ CONTEXT: SQL expression "r1.f1"
299299PL/iSQL function inline_code_block line 5 at RAISE
300300-- but OK if you assign first
301301do $$
@@ -313,7 +313,7 @@ NOTICE: r1.f1 = 1
313313NOTICE: r1.f2 = 2
314314NOTICE: r1 = (1,2)
315315ERROR: record "r1" has no field "nosuchfield"
316- CONTEXT: PL/pgSQL expression "r1.nosuchfield"
316+ CONTEXT: SQL expression "r1.nosuchfield"
317317PL/iSQL function inline_code_block line 9 at RAISE
318318-- check %type with block-qualified variable names
319319do $$
@@ -618,7 +618,7 @@ $$ begin return x.f3; end $$;
618618/
619619select getf3(null::mutable); -- doesn't work yet
620620ERROR: record "x" has no field "f3"
621- CONTEXT: PL/pgSQL expression "x.f3"
621+ CONTEXT: SQL expression "x.f3"
622622PL/iSQL function getf3(mutable) line 1 at RETURN
623623alter table mutable add column f3 int;
624624select getf3(null::mutable); -- now it works
0 commit comments