Richard Huxton writes:
> George Woodring wrote:
>> FROM
>> settop_billing
>> LEFT OUTER JOIN
>> (dhct JOIN dhct_davic USING(mac))
>> USING
>> (mac)
>> WHERE
>> region='GTown1E' AND node='1E012'
> With 7.4 I seem to remember that explicit JOI
George Woodring wrote:
explain analyze SELECT column1, column2, column3, column4, column5,
column6, column7, column8 FROM (SELECT CASE status WHEN 0 THEN 0 WHEN 1
THEN 1 ELSE -1 END AS column1, mac AS column2, account AS column3,
number || ' ' || address AS column4, 'qmod' || '.' || 'dmod' AS c
