Yes thanks that does make it clear. Martijn van Oosterhout wrote: > > On Sun, Dec 31, 2006 at 08:48:07AM -0800, novnov wrote: >> Why would not be possible in plpgsql? It has loop etc, the only part I'm >> not >> sure it can do it use the variable as field name. > > The "dynamic" in dynamic language usually refers to dynamic typing. > pl/pgsql is a strictly typed language which means one can look at the > code and determine what type each variable will be. > > Languages like perl and python are dynamic because what type a variable > is does not matter until runtime and the type can change every time you > run it. > > The problem with using a variable as a field name is that you can no > longer tell what type the result will be. It could be any type > supported by postgres. pl/pgsql can't handle that, perl and python > can... > > Hope this helps, > -- > Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ >> From each according to his ability. To each according to his ability to >> litigate. > > > -- View this message in context: http://www.nabble.com/Generic-timestamp-function-for-updates-where-field-names-vary-tf2899327.html#a8108978 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
