From tg_mail@bryncadfan.co.uk Fri Jun 29 12:40:58 2001 Received: from cmailg4.svr.pol.co.uk (cmailg4.svr.pol.co.uk [195.92.195.174]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TCewa27357 for ; Fri, 29 Jun 2001 08:40:58 -0400 (EDT) (envelope-from tg_mail@bryncadfan.co.uk) Received: from modem-943.lemur.dialup.pol.co.uk ([217.135.139.175] helo=parsley) by cmailg4.svr.pol.co.uk with smtp (Exim 3.13 #0) id 15FxZq-0004mQ-00 for pgsql-general@postgresql.org; Fri, 29 Jun 2001 13:40:52 +0100 From: "tamsin" To: Subject: RE: Date: Fri, 29 Jun 2001 13:40:04 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0002_01C100A1.00AD3310" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <001f01c0e812$33a54b60$1300a8c0@kapil1> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200106/1212 X-Sequence-Number: 11846 This is a multi-part message in MIME format. ------=_NextPart_000_0002_01C100A1.00AD3310 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit i think performance is better in postgres if you rewrite this sort of query as: select * from purchasemaster where exists (select 1 from itemmaster where itempriority = 2 and transactionid = purchasemaster.transactionid) hope this helps, tamsin -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Kapil Tilwani Sent: 28 May 2001 12:27 To: pgsql-general@postgresql.org; pgsql-sql@postgresql.org Subject: [GENERAL] Hi, I have two tables purchasemaster (Master) and ItemMaster (child) linked through TransactionID I have a query like select * from purchasemaster where transactionid in (select transactionid from itemmaster where itempriority = 2) ****I need this query for MS-Access, MS-SQL and Postgres. Because the application is supposed to be such that for upto 2-3 users, the application would be running on MS-Access or MSDE, while for heavier databases i.e., greater than 4 , the ideal database would be Postgres Only the problem is ... (correct me if i am wrong, PLEEEEEEEEEEEASE) that for each tuple in purchasemaster the sub-query is re-evaluated (True or False????). What I am looking at is whether it is possible to execute the query in the sub-query just once, get its value as in "(1,2,5,23,7,90)", etc. in place of the sub-query and accordingly, execute the main query. Thank you, Kapil ------=_NextPart_000_0002_01C100A1.00AD3310 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
i=20 think performance is better in postgres if you rewrite this sort of query= =20 as:
 
select=20 * from purchasemaster where exists (select 1 from itemmaster where=20 itempriority =3D 2 and transactionid =3D=20 purchasemaster.transactionid)
 
hope=20 this helps,
tamsin
 
-----Original Message-----
From:=20 pgsql-general-owner@postgresql.org=20 [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Kapil=20 Tilwani
Sent: 28 May 2001 12:27
To:=20 pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Subject:= =20 [GENERAL]

Hi,
 
I have two tables purchasemast= er=20 (Master) and ItemMaster (child) linked through TransactionID
 
I have a query like
select * from purchasemaster w= here=20 transactionid in (select transactionid from itemmaster where itempriority= =3D=20 2)
 
****I need this query for MS-A= ccess,=20 MS-SQL and Postgres.  Because the application is supposed to be such= that=20 for upto 2-3 users, the application would be running on MS-Access or MSDE= ,=20 while for heavier databases i.e., greater than 4 , the ideal database wou= ld be=20 Postgres
 
Only the problem is ...  = (correct=20 me if i am wrong, PLEEEEEEEEEEEASE) that for each tuple in purchasemaster= the=20 sub-query is re-evaluated (True or False????).  What I am looking at= is=20 whether it is possible to execute the query in the sub-query just once, g= et=20 its value as in "(1,2,5,23,7,90)", etc. in place of the sub-query and=20 accordingly, execute the main query.
 
Thank you,
Kapil
------=_NextPart_000_0002_01C100A1.00AD3310-- From veldy@veldy.net Fri Jun 29 15:59:36 2001 Received: from veldy.net (w028.z064001117.msp-mn.dsl.cnc.net [64.1.117.28]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TFxaa25054 for ; Fri, 29 Jun 2001 11:59:36 -0400 (EDT) (envelope-from veldy@veldy.net) Received: from HP2500B (localhost.veldy.net [127.0.0.1]) by veldy.net (Postfix) with SMTP id 1F7F2BAAC; Fri, 29 Jun 2001 10:59:32 -0500 (CDT) Message-ID: <003501c100b4$4ea2cd10$3028680a@tgt.com> From: "Thomas T. Veldhouse" To: "tamsin" , "PostgreSQL-general" References: Subject: Re: Date: Fri, 29 Jun 2001 10:58:11 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0032_01C1008A.6378C2F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200106/1225 X-Sequence-Number: 11859 This is a multi-part message in MIME format. ------=_NextPart_000_0032_01C1008A.6378C2F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable select pm.* from purchasemaster pm inner join itemmaster im on pm.transactionid =3D im.transactionid where im.itempriority =3D 2 Try this instead. Make sure the appropriate indexes (on pm.transactionid, im.transactionid an= d im.itempriority) exist if the tables are of any appreciable size.=20=20 Tom Veldhouse veldy@veldy.net ----- Original Message -----=20 From: tamsin=20 To: pgsql-general@postgresql.org=20 Sent: Friday, June 29, 2001 7:40 AM Subject: RE: [GENERAL]=20 i think performance is better in postgres if you rewrite this sort of que= ry as: select * from purchasemaster where exists (select 1 from itemmaster where= itempriority =3D 2 and transactionid =3D purchasemaster.transactionid) hope this helps, tamsin -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@po= stgresql.org]On Behalf Of Kapil Tilwani Sent: 28 May 2001 12:27 To: pgsql-general@postgresql.org; pgsql-sql@postgresql.org Subject: [GENERAL]=20 Hi, I have two tables purchasemaster (Master) and ItemMaster (child) linked= through TransactionID I have a query like select * from purchasemaster where transactionid in (select transaction= id from itemmaster where itempriority =3D 2) ****I need this query for MS-Access, MS-SQL and Postgres. Because the = application is supposed to be such that for upto 2-3 users, the application= would be running on MS-Access or MSDE, while for heavier databases i.e., g= reater than 4 , the ideal database would be Postgres Only the problem is ... (correct me if i am wrong, PLEEEEEEEEEEEASE) t= hat for each tuple in purchasemaster the sub-query is re-evaluated (True or= False????). What I am looking at is whether it is possible to execute the= query in the sub-query just once, get its value as in "(1,2,5,23,7,90)", e= tc. in place of the sub-query and accordingly, execute the main query. Thank you, Kapil ------=_NextPart_000_0032_01C1008A.6378C2F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
select pm.*
from purchasemaster pm
&= nbsp;=20 inner join itemmaster im
    on pm.transactionid =3D=20 im.transactionid
where im.itempriority =3D 2
 
Try this instead.
 
Make sure the appropriate indexes (on=20 pm.transactionid, im.transactionid and im.itempriority) exist if the t= ables=20 are of any appreciable size. 
 
Tom Veldhouse
veldy@veldy.net
 
----- Original Message -----
Fro= m:=20 tamsin
Sent: Friday, June 29, 2001 7:40 A= M
Subject: RE: [GENERAL]

i=20 think performance is better in postgres if you rewrite this sort of query= =20 as:
 
select * from purchasemaster where exists=20 (select 1 from itemmaster where itempriority =3D 2 and transactionid= =3D=20 purchasemaster.transactionid)
 
hope=20 this helps,
tamsin
 
-----Original Message-----
From: pgsql-general-owner@= postgresql.org=20 [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Kapil=20 Tilwani
Sent: 28 May 2001 12:27
To:=20 pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Subject:=20 [GENERAL]

Hi,
 
I have two tables purchasema= ster=20 (Master) and ItemMaster (child) linked through TransactionID
 
I have a query like
select * from purchasemaster= where=20 transactionid in (select transactionid from itemmaster where itempriori= ty =3D=20 2)
 
****I need this query for MS= -Access,=20 MS-SQL and Postgres.  Because the application is supposed to be su= ch=20 that for upto 2-3 users, the application would be running on MS-Access = or=20 MSDE, while for heavier databases i.e., greater than 4 , the ideal data= base=20 would be Postgres
 
Only the problem is ... = ;=20 (correct me if i am wrong, PLEEEEEEEEEEEASE) that for each tuple in=20 purchasemaster the sub-query is re-evaluated (True or False????). = What=20 I am looking at is whether it is possible to execute the query in the= =20 sub-query just once, get its value as in "(1,2,5,23,7,90)", etc. in pla= ce of=20 the sub-query and accordingly, execute the main query.
 
Thank you,
Kapil
------=_NextPart_000_0032_01C1008A.6378C2F0-- From veldy@veldy.net Fri Jun 29 16:32:44 2001 Received: from veldy.net (w028.z064001117.msp-mn.dsl.cnc.net [64.1.117.28]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TGWha39859 for ; Fri, 29 Jun 2001 12:32:44 -0400 (EDT) (envelope-from veldy@veldy.net) Received: from HP2500B (localhost.veldy.net [127.0.0.1]) by veldy.net (Postfix) with SMTP id 1F993BAAC; Fri, 29 Jun 2001 11:32:40 -0500 (CDT) Message-ID: <009d01c100b8$ef4b8190$3028680a@tgt.com> From: "Thomas T. Veldhouse" To: "tamsin" , "PostgreSQL-general" References: <003501c100b4$4ea2cd10$3028680a@tgt.com> Subject: Re: Date: Fri, 29 Jun 2001 11:31:22 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_009A_01C1008F.06109D40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200106/1230 X-Sequence-Number: 11864 This is a multi-part message in MIME format. ------=_NextPart_000_009A_01C1008F.06109D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Heck, you could refine it this way as well. select pm.* from purchasemaster pm inner join itemmaster im on (pm.transactionid =3D im.transactionid and im.itempriority =3D 2) This might reduce memory usage. I am not sure which will turn out to perfo= rm better in a resource friendly environment. Tom Veldhouse veldy@veldy.net PS There is a lot of HTML email on this list. Is this generally considere= d good? Or should I convert my replies to text? ----- Original Message -----=20 From: Thomas T. Veldhouse=20 To: tamsin ; PostgreSQL-general=20 Sent: Friday, June 29, 2001 10:58 AM Subject: Re: [GENERAL]=20 select pm.* from purchasemaster pm inner join itemmaster im on pm.transactionid =3D im.transactionid where im.itempriority =3D 2 Try this instead. Make sure the appropriate indexes (on pm.transactionid, im.transactionid = and im.itempriority) exist if the tables are of any appreciable size.=20=20 Tom Veldhouse veldy@veldy.net ----- Original Message -----=20 From: tamsin=20 To: pgsql-general@postgresql.org=20 Sent: Friday, June 29, 2001 7:40 AM Subject: RE: [GENERAL]=20 i think performance is better in postgres if you rewrite this sort of q= uery as: select * from purchasemaster where exists (select 1 from itemmaster whe= re itempriority =3D 2 and transactionid =3D purchasemaster.transactionid) hope this helps, tamsin -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@= postgresql.org]On Behalf Of Kapil Tilwani Sent: 28 May 2001 12:27 To: pgsql-general@postgresql.org; pgsql-sql@postgresql.org Subject: [GENERAL]=20 Hi, I have two tables purchasemaster (Master) and ItemMaster (child) link= ed through TransactionID I have a query like select * from purchasemaster where transactionid in (select transacti= onid from itemmaster where itempriority =3D 2) ****I need this query for MS-Access, MS-SQL and Postgres. Because th= e application is supposed to be such that for upto 2-3 users, the applicati= on would be running on MS-Access or MSDE, while for heavier databases i.e.,= greater than 4 , the ideal database would be Postgres Only the problem is ... (correct me if i am wrong, PLEEEEEEEEEEEASE)= that for each tuple in purchasemaster the sub-query is re-evaluated (True = or False????). What I am looking at is whether it is possible to execute t= he query in the sub-query just once, get its value as in "(1,2,5,23,7,90)",= etc. in place of the sub-query and accordingly, execute the main query. Thank you, Kapil ------=_NextPart_000_009A_01C1008F.06109D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Heck, you could refine it this way as=20 well.
 
select pm.*
from purchasemaster pm
&= nbsp;=20 inner join itemmaster im
    on (pm.transactionid =3D=20 im.transactionid and im.itempriority =3D 2)
 
 
This might reduce memory usage.  I am not sure which will turn ou= t to=20 perform better in a resource friendly environment.
 
Tom Veldhouse
 
PS  There is a lot of HTML email on this list.  Is this gene= rally=20 considered good?  Or should I convert my replies to text?
 

----- Original Message -----
Fro= m:=20 Thomas T. Veld= house=20
To: tamsin ; PostgreSQL-general
Sent: Friday, June 29, 2001 10:58= =20 AM
Subject: Re: [GENERAL]

select pm.*
from purchasemaster pm =20 inner join itemmaster im
    on pm.transactionid =3D=20 im.transactionid
where im.itempriority =3D 2
 
Try this instead.
 
Make sure the appropriate indexes (on=20 pm.transactionid, im.transactionid and im.itempriority) exist if the= =20 tables are of any appreciable size. 
 
Tom Veldhouse
veldy@veldy.net
 
----- Original Message -----
F= rom:=20 tamsin
To: pgsql-general@postgresql.o= rg=20
Sent: Friday, June 29, 2001 7:40= =20 AM
Subject: RE: [GENERAL]

i=20 think performance is better in postgres if you rewrite this sort of que= ry=20 as:
 
select * from purchasemaster where exists=20 (select 1 from itemmaster where itempriority =3D 2 and transaction= id =3D=20 purchasemaster.transactionid)
 
hope this helps,
tamsin
 
-----Original Message-----
From: pgsql-general-owne= r@postgresql.org=20 [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Kapil= =20 Tilwani
Sent: 28 May 2001 12:27
To:=20 pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Subject:= =20 [GENERAL]

Hi,
 
I have two tables purchase= master=20 (Master) and ItemMaster (child) linked through TransactionID
 
I have a query like=
select * from purchasemast= er where=20 transactionid in (select transactionid from itemmaster where itemprio= rity=20 =3D 2)
 
****I need this query for= =20 MS-Access, MS-SQL and Postgres.  Because the application is supp= osed=20 to be such that for upto 2-3 users, the application would be running = on=20 MS-Access or MSDE, while for heavier databases i.e., greater than 4 ,= the=20 ideal database would be Postgres
 
Only the problem is ...&nb= sp;=20 (correct me if i am wrong, PLEEEEEEEEEEEASE) that for each tuple in= =20 purchasemaster the sub-query is re-evaluated (True or False????).&nbs= p;=20 What I am looking at is whether it is possible to execute the query i= n the=20 sub-query just once, get its value as in "(1,2,5,23,7,90)", etc. in p= lace=20 of the sub-query and accordingly, execute the main=20 query.
 
Thank you,
Kapil
= ------=_NextPart_000_009A_01C1008F.06109D40-- From JanWieck@Yahoo.com Fri Jun 29 17:26:37 2001 Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5THQba65081 for ; Fri, 29 Jun 2001 13:26:37 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 29 Jun 2001 17:26:35 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f5THXBT08879; Fri, 29 Jun 2001 13:33:11 -0400 From: Jan Wieck Message-Id: <200106291733.f5THXBT08879@jupiter.us.greatbridge.com> Subject: Re: In-Reply-To: <009d01c100b8$ef4b8190$3028680a@tgt.com> from "Thomas T. Veldhouse" at "Jun 29, 2001 11:31:22 am" To: "Thomas T. Veldhouse" Date: Fri, 29 Jun 2001 13:33:11 -0400 (EDT) CC: tamsin , PostgreSQL-general X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/1237 X-Sequence-Number: 11871 Thomas T. Veldhouse wrote: > > PS There is a lot of HTML email on this list. Is this generally considered good? Or should I convert my replies to text? > This is generally considered annoying, as lines >80 characters are :-P Wasn't meant offensive - just couldn't resist. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com From tgl@sss.pgh.pa.us Fri Jun 29 18:02:29 2001 Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TI2Ra82227 for ; Fri, 29 Jun 2001 14:02:29 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5TI1fF14565; Fri, 29 Jun 2001 14:01:45 -0400 (EDT) To: "Thomas T. Veldhouse" cc: "tamsin" , "PostgreSQL-general" Subject: Re: Plain text vs HTML mail In-reply-to: <009d01c100b8$ef4b8190$3028680a@tgt.com> References: <003501c100b4$4ea2cd10$3028680a@tgt.com> <009d01c100b8$ef4b8190$3028680a@tgt.com> Comments: In-reply-to "Thomas T. Veldhouse" message dated "Fri, 29 Jun 2001 11:31:22 -0500" Date: Fri, 29 Jun 2001 14:01:41 -0400 Message-ID: <14562.993837701@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/1239 X-Sequence-Number: 11873 "Thomas T. Veldhouse" writes: > PS There is a lot of HTML email on this list. Is this generally considere= > d good? Or should I convert my replies to text? This is generally considered evil. Plain text messages are preferred. HTML is harder to quote when replying, and the variants that send both HTML and plain text bloat the archives far more than necessary. regards, tom lane From pgman@candle.pha.pa.us Fri Jun 29 18:32:39 2001 Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TIWda95586 for ; Fri, 29 Jun 2001 14:32:39 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f5TIVX407495; Fri, 29 Jun 2001 14:31:33 -0400 (EDT) From: Bruce Momjian Message-Id: <200106291831.f5TIVX407495@candle.pha.pa.us> Subject: Re: In-Reply-To: <200106291733.f5THXBT08879@jupiter.us.greatbridge.com> "from Jan Wieck at Jun 29, 2001 01:33:11 pm" To: Jan Wieck Date: Fri, 29 Jun 2001 14:31:33 -0400 (EDT) CC: "Thomas T. Veldhouse" , tamsin , PostgreSQL-general X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200106/1243 X-Sequence-Number: 11881 > Thomas T. Veldhouse wrote: > > > > PS There is a lot of HTML email on this list. Is this generally considered good? Or should I convert my replies to text? > > > > This is generally considered annoying, as lines >80 > characters are :-P > > Wasn't meant offensive - just couldn't resist. Let's not forget email with no subject, like this one. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 From JanWieck@Yahoo.com Fri Jun 29 18:41:36 2001 Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5TIfaa99931 for ; Fri, 29 Jun 2001 14:41:36 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 29 Jun 2001 18:41:34 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f5TIljj13422; Fri, 29 Jun 2001 14:47:45 -0400 From: Jan Wieck Message-Id: <200106291847.f5TIljj13422@jupiter.us.greatbridge.com> Subject: Re: (was: ) In-Reply-To: <200106291831.f5TIVX407495@candle.pha.pa.us> from Bruce Momjian at "Jun 29, 2001 02:31:33 pm" To: Bruce Momjian Date: Fri, 29 Jun 2001 14:47:45 -0400 (EDT) CC: Jan Wieck , "Thomas T. Veldhouse" , tamsin , PostgreSQL-general X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/1244 X-Sequence-Number: 11878 Bruce Momjian wrote: > > Thomas T. Veldhouse wrote: > > > > > > PS There is a lot of HTML email on this list. Is this generally considered good? Or should I convert my replies to text? > > > > > > > This is generally considered annoying, as lines >80 > > characters are :-P > > > > Wasn't meant offensive - just couldn't resist. > > Let's not forget email with no subject, like this one. Come on, let's create some mega-off-topic thread about if "Re: [GENERAL]" is a subject or not. :-) Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com