CREATE FUNCTION count_light() RETURNS integer AS $$
import Queue
class good:
       	 def __init__(self,id,type):
              		  self.id = id
               	  self.type = type
	def getint(self):
        		  return self.id
	def __str__(self):
        		  return "'%s'" % \
		    self.id

q = Queue.Queue()
r = Queue.Queue()
sumlightbulb = 0
cursor = plpy.execute("select id,type from objects where type = 2;")

#for rec in cursor:
	#id, type = rec
q.put(good(1,2))

plan = plpy.prepare("select line.id_end,objects.type from line join objects on objects.work = 1 and \
objects.id = line.id_end where line.id_start = $1 and line.work = 1", [ "integer" ])

# получаем результат выполнения запроса
while not q.empty():
	q_object = q.get()
	#plpy.debug(q_object.__int__())
	cursor = plpy.execute(plan,[q_object.getint()])
	# перебираем записи
	for rec in cursor:
        	# извлекаем данные из записей - в том же порядке, как и в SQL-запросе
        	id = rec.id_end
		type = rec.type
		if type == 0:
			q.put(good(id,type))
		if type == 1:
			#r.put(id)
			sumlightbulb = sumlightbulb + 1
		if type == 2:
			q.put(good(id,type))

#printing(r,"lightbulbWork: ")
return sumlightbulb
$$ LANGUAGE plpythonu;