Hello -
I'm using PG 8.2. I have the following code snippet:
adServerLoadRow domain2_dom%ROWTYPE;
attName text;
line text;
i int;
i = 3;
attName := split_part(line,E'\t',i);
adServerLoadRow.quote_literal(attName) = split_part(line,'\t',i+1);
The error message I receive is
ERROR: row "adserverloadrow" has no field "quote_literal"
SQL state: 42703
Context: compile of PL/pgSQL function "adserverfunctionbody" near line 57
I'm trying to dynamically assign values to attributes in a record without know which attribute values I will actually receive. I will always receive at least two key-value pairs with the elements separated by tabs.
I have tried both quote_literal and quote_ident with the same result. Any advice or suggestions would be much appreciated.
Thank you.
David