Re: [GENERAL] Pronouncing PostgreSQL

2003-12-03 Thread Williams, Travis L, NEO
They're used to be a sound bite on postgres.org on how to pronounce it properly.. any idea where that went? Travis -Original Message- From: Marc G. Fournier [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 7:46 PM To: Craig O'Shannessy Cc: Chris Stokes; John Wells; [EMAIL PROT

[GENERAL] Group and grant question

2003-10-15 Thread Williams, Travis L, NEO
1) how can I tell which users are in my group? 2) I have granted all to a group but they can not alter my table.. is that correct? I'm using 7.2 Travis ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Problem with ORDER BY and random() ?

2003-09-23 Thread Williams, Travis L, NEO
so.. what exactly are you trying to say here? ;) I think this is the funniest post I've ever seen on this list!!! Travis -Original Message- From: Nigel J. Andrews [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 5:47 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re:

Re: need for in-place upgrades (was Re: [GENERAL] State of

2003-09-14 Thread Williams, Travis L, NEO
Not that my DB is that big.. but if it was and it contained any sort of financial data (something that you might want to dispute 2 years down the road) then I would have multiple replicated systems (which I do have .. but they are MSSQL) and I would also be backing the data up to an offsite storag

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
ugust 29, 2003 12:44 AM To: Williams, Travis L, NEO Cc: Thomas A. Lowery; [EMAIL PROTECTED] Subject: Re: [GENERAL] Join question On Friday, August 29, 2003, at 12:36 AM, Williams, Travis L, NEO wrote: > Performace wise would I be better off just doing 2 query's.. i.e. > select &

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
btw.. thanks for all the help. Travis -Original Message- From: Jeffrey Melloy [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:32 AM To: Williams, Travis L, NEO Cc: Thomas A. Lowery; [EMAIL PROTECTED] Subject: Re: [GENERAL] Join question On Thursday, August 28, 2003, at 09:03

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
3 12:32 AM To: Williams, Travis L, NEO Cc: Thomas A. Lowery; [EMAIL PROTECTED] Subject: Re: [GENERAL] Join question On Thursday, August 28, 2003, at 09:03 PM, Williams, Travis L, NEO wrote: >> I have a table1 with 2 col (a & b) where b can sometimes be null. I >> need a query th

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
Yeah.. so that's why I didn't know if I could do it all in the same statement. Travis -Original Message- From: Thomas A. Lowery [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 8:54 PM To: Williams, Travis L, NEO Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Join que

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
n Thu, Aug 28, 2003 at 05:55:27PM -0400, Williams, Travis L, NEO wrote: > Question, > > I have a table (1) with 2 col (a & b) where b can sometimes be null. I > need a query that if B is null I get back the contents of A.. but if B > is not null I do a join on it and table (2) col

Re: [GENERAL] Join question

2003-08-29 Thread Williams, Travis L, NEO
n question Does using a union count as one query? select a from tst_1 where b is null union select d from tst_2 t2 join tst_1 t1 on (t1.b = t2.c) where t1.b is NOT null On Thu, Aug 28, 2003 at 05:55:27PM -0400, Williams, Travis L, NEO wrote: > Question, > > I have a table (1) with 2 col