des1roer

#!/usr/bin/python
# -*- coding: utf-8 -*-

import psycopg2
import sys


con = None

try:
     
    con = psycopg2.connect(database='testdb', user='janbodnar') 
    cur = con.cursor()
    cur.execute('SELECT 1 from mytable')          
    ver = cur.fetchone()
    print ver    //здесь наш код при успехе
    

except psycopg2.DatabaseError, e:
    print 'Error %s' % e    
    sys.exit(1)
    
    
finally:
    
    if con:
        con.close()

select *  from (
select t.*, abs(value - 1.1) as diff
from   t
order by diff asc  
limit 2
) x
order by value

select * from 
    crosstab('SELECT 
            t1.analiz_id,
            t1.elem_id,
              t1.value
            FROM 
              a_analiz_data t1
            WHERE
              t1.analiz_id =36
                            ', //analiz_id - общий ид, 
            //elem_id - имя элемента
            //value - отображаемое значение
    '       SELECT 
  elem_id //elem_id - видимо нужен для связи двух таблиц
    FROM 
    a_analiz_data t1
  WHERE                            
     t1.analiz_id = 36')
as (rowid int, att1 text, att2 text, att3 text, att4 text, att5 text, att6 text, att7 text);

SELECT 
  t1.value,
  t1.elem_id
FROM 
  a_analiz_data t1
WHERE
  t1.analiz_id =36