[SQL] Join Question

2002-09-17 Thread Robert J. Sanford, Jr.
My office is working on a fantasy football database and, unfortunately, I have been tagged as the DBA. I'm a bit weak on set theory but I'm trying. Right now I am trying to calculate up game scores into the database rather than running through code to do that. A baseline of my schema is that: + E

[SQL] optimizing queries and indexes...

2001-09-07 Thread Robert J. Sanford, Jr.
i'm fairly new at this whole database design thing and my grasp of set theory is not what it was when i was in college lo these many years past. but i want to get a better idea of how to optimize sql statements. i have several friends that are DBA's by profession and work on oracle and/or ms sql

RE: [SQL] user defined function question

2001-08-20 Thread Robert J. Sanford, Jr.
you can't. rjsjr > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph Syjuco > Sent: Tuesday, August 14, 2001 10:34 PM > To: [EMAIL PROTECTED] > Subject: [SQL] user defined function question > > > how do i return a resultset from a user defined

[SQL] result sets from functions...

2001-08-14 Thread Robert J. Sanford, Jr.
i'm reading the postgres documentation and i'm specifically interested in creating stored procedures so that i can keep as much of the business logic in the database as possible. while reading 13.1.3 (SQL Functions on Composite Types) in the Programmer's Guide i come across the phrase... "When