Search Postgresql Archives

can this be done in one SQL selcet statement?!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I have two table:
-Table1: one column of type TEXT containing label for nodes in a graph

-Table 2: two columns of type TEXT. first column contains node labels
in a graph. second a list of node labels that the node label in column
one is connected to.

Example:
    Table1:
         "NODE1"
         "NODE2"

    Table 2:
          "NODE1"    "NODE2 NODE3"
          "NODE2"    "NODE4 NODE3"

Goal:
     split column2 in table2 to individual node names, find a unique
list of all node names obtained after splitting column2 of table2 and
insert the ones not already in table1 in table1.


Thanks in advance.

S



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux