data types

SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz665.text v665, zz661.text v661, zz662.int v662, zz663.num v663, COALESCE(zz664.bit, False) v664, zz666.date v666 FROM drs LEFT JOIN zz665 ON zz665.dr=drs.id LEFT JOIN zz661 ON zz661.dr=drs.id LEFT JOIN zz662 ON zz662.dr=drs.id LEFT JOIN zz663 ON zz663.dr=drs.id LEFT JOIN zz664 ON zz664.dr=drs.id LEFT JOIN zz666 ON zz666.dr=drs.id WHERE module = 660 and drs.hidden = false ORDER BY drs.id NULLS FIRST LIMIT 1000

---

[]

---

0.057510137558, 0.0852980613708

ID	unchanged	text	integer	decimal	checkbox	date
1604	one	one	1	1.1	True	1/1/2001	1604, one, one, 1, 1.1, True, 1/1/2001
1605	two	two	22	2.22	True	2/22/2002	1605, two, two, 22, 2.22, True, 2/22/2002
1606	three	three	3	3.3	False	3/3/2003	1606, three, three, 3, 3.3, False, 3/3/2003
1607	four	four	4	4.4	False	4/4/2004	1607, four, four, 4, 4.4, False, 4/4/2004
1608	mostly blank		0	0.0	False		1608, mostly blank, , 0, 0.0, False,