On Thu, Mar 5, 2009 at 8:32 PM, Sophie Yang <[email protected]> wrote: > > I was wondering why USING clause is not supported in pl/pgsql dynamic > statement. Serialization is the option I tried to avoid, but it seems there > is no better approach available. > > Just to say a few more about the usage of my function. In dag_tree_1, (rid, > rtid) is the primary key, which identifies a node in a tree structure. The > idx field is a kind of dewy index. for example: > rid rtid idx > 1123 1 0000.0006.0033 > 3231 1 0000.0006 > 786 6 0000.0007.8853 > 80923 2 0000.0007.8853.2382 > > The function takes in a list of rid and rtid pair (nids), sort them by the > length of the dewy index, which is equivalent to sort the nodes by their tree > depth. That's what I try to achieve. Maybe someone has different idea to > implement the function?
Well the function is pretty simple. Maybe you could merge the logic encapsulated by the function into the containing query? ...Robert -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
