(new) Databases

Anyone point to a good howto for postgres installation? - (drewk) - (2) - May 1, 2004, 08:29:33 PM EDT

Take a look on Knight and Lord. - (folkert) - (1) - May 1, 2004, 10:11:41 PM EDT

Got it somewhat figured out - (drewk) - May 1, 2004, 10:21:48 PM EDT

Is there any DB without a current_date function? - (FuManChu) - (9) - April 30, 2004, 02:39:23 PM EDT

Firebird has CURRENT_DATE, CURRENT_TIME, & CURRENT_TIMESTAMP -NT - (CRConrad) - (5) - May 4, 2004, 02:45:46 AM EDT

Also: CURRENT_SHILL, CURRENT_CRC, CURRENT_CRCERROR -NT - (folkert) - (4) - May 4, 2004, 01:29:58 PM EDT

Ob:Eiks taeae vittun homma nyt riitaeae taestae paeivaestae? -NT - (CRConrad) - (3) - May 5, 2004, 02:45:56 AM EDT

Nah, didn't mean to accuse you of anything... - (folkert) - (2) - May 5, 2004, 10:18:56 PM EDT

Likewise. (I don't believe in Babelfishing Finnish, BTW. :-) -NT - (CRConrad) - May 5, 2004, 05:31:33 PM EDT

Believe even less in Merkins getting Finnish without it! :-) -NT - (CRConrad) - May 6, 2004, 07:12:45 AM EDT

Resource Link - (ChrisR) - (2) - May 8, 2004, 09:57:11 PM EDT

very useful, thanx -NT - (boxley) - May 8, 2004, 10:12:30 PM EDT

Excellent! Vielen dank -NT - (FuManChu) - May 9, 2004, 10:40:49 AM EDT

Beware Access 2003. - (acagle) - (8) - April 23, 2004, 01:48:19 PM EDT

Access 2002 does that too. - (altmann) - April 23, 2004, 03:10:55 PM EDT

Unique constraint is to blame. - (mmoffitt) - April 23, 2004, 09:51:43 PM EDT

Correct. Tables and queries share the same namespace. - (rickw) - (3) - April 26, 2004, 12:07:28 PM EDT

Re: Correct. Tables and queries share the same namespace. - (acagle) - (2) - April 26, 2004, 01:07:56 PM EDT

Yeah...me too... - (rickw) - (1) - May 5, 2004, 01:55:48 PM EDT

ICLRPD (new thread) - (Another Scott) - May 5, 2004, 01:59:55 PM EDT

Access Weird Behavior #233. - (acagle) - (1) - April 28, 2004, 12:29:59 PM EDT

Note: It's a bug. - (acagle) - April 28, 2004, 12:42:11 PM EDT

How do I pass parameters to a Query in Access - (jbrabeck) - (12) - April 19, 2004, 01:11:31 PM EDT

Re: How do I pass parameters to a Query in Access - (JayMehaffey) - April 19, 2004, 01:40:00 PM EDT

For *very* simple stuff - (FuManChu) - (7) - April 19, 2004, 02:06:16 PM EDT

Here's the SQL code. - (jbrabeck) - (4) - April 19, 2004, 03:20:01 PM EDT

Reformatting a bit - (ChrisR) - April 19, 2004, 03:53:17 PM EDT

Are all of those date parts from a single date? - (FuManChu) - (2) - April 19, 2004, 04:40:43 PM EDT

More - (jbrabeck) - (1) - April 19, 2004, 04:55:09 PM EDT

Sorry - (JayMehaffey) - April 19, 2004, 05:19:22 PM EDT

Re: For *very* simple stuff - (andread) - (1) - April 19, 2004, 03:21:26 PM EDT

Or "query by form" -NT - (mmoffitt) - April 19, 2004, 04:38:56 PM EDT

Found a way - (jbrabeck) - April 20, 2004, 02:24:10 PM EDT

Different approach is DoCmd.RunSQL - (rickw) - (1) - April 26, 2004, 12:48:43 PM EDT

How I've got it running - (jbrabeck) - April 26, 2004, 02:46:40 PM EDT

Slow query needs optimizing - (tangaroa) - (19) - April 16, 2004, 02:52:55 AM EDT

Re: Slow query needs optimizing - (pwhysall) - (3) - April 16, 2004, 07:02:04 AM EDT

Just imagine a Beowolf cluster of those. -NT - (ChrisR) - (2) - April 16, 2004, 11:33:33 AM EDT

Great, now we're turning into /. - (inthane-chan) - April 16, 2004, 11:36:50 AM EDT

Running DOSiX! -NT - (Another Scott) - April 16, 2004, 11:50:39 AM EDT

Can you post - (jbrabeck) - (6) - April 16, 2004, 09:55:24 AM EDT

'fraid not - (tangaroa) - (5) - April 16, 2004, 06:11:09 PM EDT

pump to file, cat file |sort -k3 >outputfile - (boxley) - April 16, 2004, 10:48:21 PM EDT

If you're allowed correlated subquery, then: - (morganek) - (1) - April 16, 2004, 11:43:11 PM EDT

Re: If you're allowed correlated subquery, then: - (tangaroa) - April 17, 2004, 12:12:09 AM EDT

Re: 'fraid not - (JayMehaffey) - (1) - April 17, 2004, 01:43:40 AM EDT

Is "SQL Sever" intentional? (Regardless, I like it. :-) -NT - (ben_tilly) - April 17, 2004, 01:49:40 AM EDT

I don't recognize the "within" clause - (ben_tilly) - April 16, 2004, 01:47:40 PM EDT

Not quite sure what you are doing - (JayMehaffey) - (6) - April 16, 2004, 03:49:51 PM EDT

Whew, glad it's not just me that didn't understand. -NT - (jbrabeck) - April 16, 2004, 04:02:30 PM EDT

Pet peeve on SQLServer - (ChrisR) - (4) - April 16, 2004, 04:38:14 PM EDT

Rarely use real temporary tables - (JayMehaffey) - (3) - April 16, 2004, 05:27:44 PM EDT

I just finished writing about 15 stored procedures. - (mmoffitt) - (2) - April 16, 2004, 08:09:35 PM EDT

Table variables are great - (ChrisR) - (1) - April 16, 2004, 08:37:19 PM EDT

Thanks. - (mmoffitt) - April 18, 2004, 12:26:23 PM EDT

Concentration to fewer IT players marches relentlessly on... - (CRConrad) - April 7, 2004, 09:56:02 AM EDT

Oracle: 'DECODE' performance impact? - (Meerkat) - (19) - April 6, 2004, 09:47:12 PM EDT

Highly unlikely - (ben_tilly) - (4) - April 6, 2004, 10:14:19 PM EDT

Sounds like a great book - (Meerkat) - (3) - April 6, 2004, 10:28:33 PM EDT

Re: Sounds like a great book - (kelzer) - (2) - April 7, 2004, 06:11:50 PM EDT

Heh. We've got a comedian among us. - (Another Scott) - April 7, 2004, 06:16:56 PM EDT

My subconscious inadvertantly told you all - (Meerkat) - April 7, 2004, 11:59:02 PM EDT

Depends on what clause - (ChrisR) - (3) - April 6, 2004, 10:52:32 PM EDT

Just to clarify that - (ben_tilly) - (2) - April 7, 2004, 01:14:51 AM EDT

It's just in the SELECT clause - (Meerkat) - (1) - April 7, 2004, 02:02:20 AM EDT

Functions in the WHERE can be fine - (ben_tilly) - April 7, 2004, 10:57:43 AM EDT

Belated answer: "What they said". - (CRConrad) - (8) - April 7, 2004, 09:50:49 AM EDT

Transposing rows to columns is a PITA - (ben_tilly) - (7) - April 7, 2004, 10:50:12 AM EDT

"When the only tool you have is a hammer..." - (CRConrad) - (6) - April 8, 2004, 01:52:00 AM EDT

But that isn't the only tool that I have - (ben_tilly) - (5) - April 8, 2004, 02:23:07 AM EDT

At least Perl is a good hammer to have - (Meerkat) - (3) - April 8, 2004, 03:02:39 AM EDT

use that one a lot - (Steve Lowe) - (2) - April 8, 2004, 03:12:58 AM EDT

I don't like it - (broomberg) - (1) - April 22, 2004, 10:58:47 PM EDT

No feedback? That's what top / glance is for :) -NT - (Meerkat) - April 23, 2004, 02:23:05 AM EDT

No no no, you misunderstand! - (CRConrad) - April 8, 2004, 03:11:51 AM EDT

Eliminate decode wherever you can - (tuberculosis) - April 9, 2004, 03:01:43 AM EDT

Could you do multi-master replication for < $1-million? - (drewk) - (11) - March 29, 2004, 11:35:18 AM EST

Sure, T3's :-) -NT - (boxley) - (1) - March 29, 2004, 11:55:31 AM EST

/me smacks forehead - (drewk) - March 29, 2004, 12:17:47 PM EST

Well from a support guy point of view - (boxley) - (2) - March 29, 2004, 12:29:08 PM EST

That's one of the things we're considering - (drewk) - (1) - March 29, 2004, 01:02:26 PM EST

well with the thin clients pointing to an webserver at the - (boxley) - March 29, 2004, 01:16:28 PM EST

Does this answer your question about PG? - (folkert) - (5) - March 29, 2004, 02:18:23 PM EST

Much cool - (drewk) - (4) - March 29, 2004, 02:21:06 PM EST

Willingness to spend some of that <$1million might help :-P -NT - (ben_tilly) - (1) - March 29, 2004, 02:27:53 PM EST

We are ... ___________________________________ No, seriously - (drewk) - March 29, 2004, 02:33:49 PM EST

Goto: - (folkert) - (1) - March 29, 2004, 03:47:03 PM EST

Will do, thanks for the pointers -NT - (drewk) - March 29, 2004, 05:12:13 PM EST

Need a multi-master replication solution - (drewk) - March 25, 2004, 04:04:56 PM EST

Postgres users: functions - (admin) - (5) - March 23, 2004, 09:36:23 AM EST

Thanks. -NT - (mmoffitt) - March 23, 2004, 09:40:46 AM EST

Oracle is similar - (ben_tilly) - (3) - March 23, 2004, 11:11:54 AM EST

OT - recommend a Perl refresher project for tomorrow? - (deSitter) - (2) - March 23, 2004, 11:28:13 AM EST

You'll be dealing with Informix? - (ben_tilly) - (1) - March 23, 2004, 11:34:47 AM EST

Thanks, excellent advice -NT - (deSitter) - March 23, 2004, 11:36:29 AM EST

Welcome to IWETHEY!