[GENERAL] Thanks and questions...

2000-07-28 Thread George Robinson II
I'm new to postgres, but I've quickly become a big fan. Thank you for such a great project and I hope in the future to be able to contribute to the effort. I'm a newbie to the list and as such, I haven't have much of a change to lurk. I hope my explanation isn't too long and my q

[GENERAL] Interval examples

2000-08-15 Thread George Robinson II
Could someone please send me some examples of the interval data type? For example, what should the data look like in order to do and insert? If I have two iso time stamps, how can I insert them into the interval datatype? What are some ways to format the output of an interval type?

[GENERAL] Referential integrity

2000-08-15 Thread George Robinson II
Hi again. Still new to databases, and I was wondering if I could get advice on how to set this up right. Essentially, I have a table, lets call it main, in which each row, describes another table in the database. I want to set it up so that, dropping the table will also drop the associa

[GENERAL] YAIQ (yet another inane question)

2000-08-16 Thread George Robinson II
Actually, this isn't so inane... Let's say I have table A keeping track of other tables, and those tables detail bandwidth usage. I want to do a subselect like the flowing, but I'm not sure how. Take a look. Any ideas? Thanks. -g2 SELECT *, SUM(octets)