By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

More Praise! 7.4

P: n/a


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.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.