19 messages in org.postgresql.pgsql-generalRE: dynamic field names in a function.
FromSent OnAttachments
Soma InterestingMar 29, 2001 2:38 pm 
Jeff EckermannMar 30, 2001 9:29 am 
Soma InterestingMar 30, 2001 10:06 am 
Soma InterestingMar 30, 2001 10:57 am 
Soma InterestingMar 30, 2001 1:58 pm 
Jeff EckermannMar 30, 2001 2:09 pm 
Soma InterestingMar 30, 2001 2:33 pm 
will trillichMar 30, 2001 3:46 pm 
Soma InterestingMar 30, 2001 4:38 pm 
will trillichMar 30, 2001 4:47 pm 
Soma InterestingMar 30, 2001 6:02 pm 
Eric G. MillerMar 30, 2001 7:29 pm 
Tom LaneMar 30, 2001 9:42 pm 
will trillichMar 30, 2001 10:04 pm 
will trillichMar 30, 2001 10:13 pm 
Tom LaneMar 31, 2001 4:57 pm 
will trillichApr 1, 2001 9:23 pm 
Tom LaneApr 1, 2001 11:27 pm 
Soma InterestingApr 3, 2001 1:23 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:RE: dynamic field names in a function.Actions...
From:Soma Interesting (dfu@telus.net)
Date:Mar 30, 2001 1:58:24 pm
List:org.postgresql.pgsql-general

At 03:43 PM 3/30/2001 -0600, you wrote:

I think I am beginning to understand your question. You want to know whether a field name can be referenced using a variable as all or part of the field name? I don't know for sure, but I can't make it work, and apparently you can't either. Your earlier message is still out on the wire, so someone more knowledgeable may still answer. If you expect the maximum number of question/answer pairs to be manageably small, you could do a series of actions for each field by name, incrementing a counter for each pair, and comparing the counter value to 'qty'. Horrible, I know, but the best I can suggest right now.

I'm going to quote your rephrasing of my question to the list, maybe your words will carry more weight as "valid" question.

Another option would be to use Tcl or Pearl, would they be able to use variables as all or part of the field name?