Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal



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


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group