[SQL] Replication

2001-10-18 Thread Hunter, Ray
Title: Replication Does Postgres in anyway support replication?  Will I be able to have load-balancing between two postgres databases? RAY HUNTER Automated Test Group Software Support Engineer   ENTERASYS NETWORKS   Internal: 53888 Phone:   801 887-9888 Fax:  801 972-5789 Cel

[SQL] Functions and Triggers

2001-06-20 Thread Hunter, Ray
Title: Functions and Triggers Is there anyone that can point me into the right direction for creating a function and trigger that will do something along these lines: I have a table that has router card types and a status on them: TEST_RECORD    CARD                STATUS 1

[SQL] Functions and Triggers

2001-06-20 Thread Hunter, Ray
Title: Functions and Triggers Is there anyone that can point me into the right direction for creating a function and trigger that will do something along these lines: I have a table that has router card types and a status on them: TEST_RECORD    CARD                STATUS 1

[SQL] Getting a specific row from a table

2001-06-13 Thread Hunter, Ray
Title: Getting a specific row from a table My problem is that I want to pull to specific rows from a query result. First here is the query: SQL-query: select card, status, time_stamp, comp_date from test_record where id = 45 order by card, comp_date Next here is the result: card   

[SQL] Functions and Triggers

2001-06-06 Thread Hunter, Ray
Title: Functions and Triggers I need help on creating a sql function that will check four rows in a table based on that check it will update another row on a different table.  I want to use this function in a trigger statement. Table 1 (Test Type) id cat sub-cat test        stat