modify query for postgresql

yes, thats a valid sql syntax :)

ALTER TABLE table_name RENAME old_column_name TO new_column_name

I got it working on Postgre, Ill submit it this evening!

Ok here they are.

I didnt test them properly but I think everything works fine. So i can create webform with any of types, then I can fill it without problems. There is only one error when viewing as table, but I know its because of query. When i clik on table i get lots of columns because i had to add more columns in GROUP BY syntax (because of postgres). Will fix it up... have to rewrite query a bit...

And .inc file.

following query is not yet final because it gives many columns , but at lest it doesnt throw errors!

  // Get all the submitted values for the node
  $query = 'SELECT sd.sid as sid, c.cid as cid, sd.name as name, sd.data as data'.
    ' FROM '.
    ' {webform_submitted_data} sd, {webform_component} c '.
    ' WHERE sd.nid = c.nid '.
    ' AND sd.nid = %d '.
    ' GROUP BY sd.sid, sd.name , c.cid, sd.data'.
    ' ORDER BY sd.sid, c.cid ';

To explain module.diff a bit:
even if I wrote function for that imploded query i used one from http://drupal.org/node/18134. It seems to do its job. There was one missing t in submitted :)

   db_query("INSERT INTO {webform_submitted_data} (nid, sid, name, data) ".
-           "VALUES ".implode(', ', $sqlstring), $values);
+             "VALUES (%d, %d, '%s', '%s')", $node->nid, $sid, $key, $value);
+    }
+
 

following query gives names of columns in table:

-  $result = db_query("SHOW FIELDS FROM {webform}");

for postgresql didn't find better solution than this one:

+$result = db_query("SELECT attname as \"Field\" FROM pg_class a INNER JOIN pg_attribute b ON a.relfilenode=b.attrelid WHERE a.relname='webform' AND NOT b.attisdropped AND b.attnum>0");

Tnx to my friend dodobas for that one:)

and how are you going to solve that select column name query? theyre pretty different :)