Thread: More Praise! 7.4

More Praise! 7.4

From
Rajesh Kumar Mallah
Date:


Its really nice to see/read  the pretty printing of
VIEW definations!! in 7.3 it was  a
nightmare to see definations of long views.

Kudos to the TEAM.


Regds
Mallah






tradein_clients=# \d XYZ
View XYZ
   Column    |       Type        | Modifiers
-------------+-------------------+-----------
 id          | integer           |
 branch      | character varying |
 source      | character varying |
 co_name     | character varying |
 address     | text              |
 city        | character varying |
 pin_code    | character varying |
 phone       | character varying |
 fax         | character varying |
 contact     | character varying |
 email       | character varying |
 size        | character varying |
 status      | boolean           |
 category_id | integer           |
 keywords    | text              |
 edition     | smallint          |
 sno         | integer           |
View definition:
 SELECT eyp_listing.list_id AS id, eyp_listing.branch, 'EYP'::character varying AS source, eyp_listing.co_name, (((
        CASE
            WHEN eyp_listing.address1 IS NOT NULL THEN eyp_listing.address1
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text || ' '::character varying::text) ||
        CASE
            WHEN eyp_listing.address2 IS NOT NULL THEN eyp_listing.address2
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text) || ' '::character varying::text) ||
        CASE
            WHEN eyp_listing.address3 IS NOT NULL THEN eyp_listing.address3
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text AS address, eyp_listing.city, eyp_listing.pin_code, eyp_listing.phone, eyp_listing.fax, eyp_listing.contact, eyp_listing.email, eyp_listing.size, true AS status, eyp_listing.category_id, eyp_listing.keywords, eyp_listing.edition, eyp_listing.sno
   FROM ONLY public.eyp_listing
  WHERE (eyp_listing.category_id = 1142 OR eyp_listing.category_id = 1143 OR eyp_listing.category_id = 1145 OR eyp_listing.category_id = 1259 OR eyp_listing.category_id = 1161) AND eyp_listing.amount > 0 AND eyp_listing.status::text = 'a'::character varying::text AND eyp_listing.email IS NOT NULL AND eyp_listing.email::text !~~* '%.trade-india.com'::text
UNION ALL
 SELECT iid_listing.list_id AS id, iid_listing.branch, 'IID'::character varying AS source, iid_listing.co_name, (((
        CASE
            WHEN iid_listing.address1 IS NOT NULL THEN iid_listing.address1
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text || ' '::character varying::text) ||
        CASE
            WHEN iid_listing.address2 IS NOT NULL THEN iid_listing.address2
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text) || ' '::character varying::text) ||
        CASE
            WHEN iid_listing.address3 IS NOT NULL THEN iid_listing.address3
            WHEN '' IS NOT NULL THEN ''::character varying
            ELSE NULL::character varying
        END::text AS address, iid_listing.city, iid_listing.pin_code, iid_listing.phone, iid_listing.fax, iid_listing.contact, iid_listing.email, iid_listing.size, true AS status, iid_listing.category_id, iid_listing.keywords, iid_listing.edition, iid_listing.sno
   FROM ONLY public.iid_listing
  WHERE (iid_listing.category_id = 1142 OR iid_listing.category_id = 1143 OR iid_listing.category_id = 1145 OR iid_listing.category_id = 1259 OR iid_listing.category_id = 1161) AND iid_listing.amount > 0 AND iid_listing.status::text = 'a'::character varying::text AND iid_listing.email::text !~~* '%.trade-india.com'::text AND iid_listing.email IS NOT NULL
UNION ALL
 SELECT DISTINCT ON (company_id) company_id AS id, trade_india_branch AS branch, 'BRANDING'::character varying AS source, comp_name AS co_name, office_addr AS address, city, pincode AS pin_code, phone_no AS phone, fax_no AS fax, key_exec AS contact, email, 'BRANDING' AS size, false AS status, category_id, serv_prov AS keywords, branding_master.edition, 0 AS sno
   FROM ONLY public.branding_master
   JOIN ONLY public.branding_sp_category USING (company_id)
  WHERE (category_id = 1142 OR category_id = 1143 OR category_id = 1145 OR category_id = 1259 OR category_id = 1161) AND old_company_id = 0 AND status::text = 'a'::character varying::text AND email::text !~~* '%.trade-india.com'::text AND email IS NOT NULL
  ORDER BY company_id;



-- 

Rajesh Kumar Mallah,
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.