Re: [GENERAL] Join question

2003-08-29 Thread Thomas A. Lowery
le1 column b in the like condition? > -Original Message- > From: Thomas A. Lowery [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 28, 2003 8:06 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Join question > > > Does using a union count as one query? > > sel

Re: [GENERAL] Join question

2003-08-29 Thread Thomas A. Lowery
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 (a & b) where b ca

Re: [GENERAL] Simple DBI question.

2003-08-14 Thread Thomas A. Lowery
On Tue, Aug 12, 2003 at 04:58:49PM -0400, David Siebert wrote: > How do I connect to a postgres sever across a network using DBI? > I can not find an example of it anywhere in any docs. connect string like "dbi:Pg:dbname=db;host=machine;port=5432" Example: use DBI; my $dbh = DBI->connect( "dbi: