[SQL] Subselect in join?

2000-11-29 Thread Kenn Thompson
use? Kenn ____ Kenn Thompson Senior Web Architect Adesta Communications Work: 402.233.7595 Cell: 402.210.6326

RE: [SQL] SQL parse error

2000-12-12 Thread Kenn Thompson
attempt should be made to offer help in the version that is being presented by the request. Sorry if this seems long-winded- it just seems that someone needed to say it... Kenn ____ Kenn Thompson Senior Web Architect Adesta Communications Work: 402.23

Re: [SQL] realising a counter in an pgpsql-trigger

2001-04-26 Thread Kenn Thompson
Hate to be entirely off topic, but can anyone help me with changing to digest version of the listserv subscription? I've been all over the site, and can't find the instructions. >>> chris G*nther <[EMAIL PROTECTED]> 04/26/01 09:17AM >>> Hi folks, I want to do the following: I have a column in

Re: [SQL] moving DB

2000-06-06 Thread Kenn Thompson
Related to this- how do you accomplish the same this while preserving the existing OIDs? >>> Christopher Sawtell <[EMAIL PROTECTED]> 06/06/00 02:33AM >>> On Sat, 12 Jul 2036, [EMAIL PROTECTED] wrote: > Hi all! > > well, can somebody tell me how to move a DB (e.g. I have a DB named NET in > PC1

[SQL] Problem with pg_dumpall in reverse

2000-06-27 Thread Kenn Thompson
Ok- this may be a simple answer, but- Once the database has been dumped, how do you restore while keeping the original OIDs? I've used the OID as a unique key that ties records together, and somehow they don't go back together nicely... doing a dump with "pg_dumpall -o -c > db.out" restoring w