[ADMIN] Foreign key split across two tables

2000-12-08 Thread Raju Mathur
Hi, Checked out the complete manual but I can't see a simple answer for this one: I have an invoice which I'm representing as two tables in the schema: the invoice header and the line items. One of the tables referred is the customer table, which uses customer number and location as the key. M

[ADMIN] CURSOR HELP

2000-12-08 Thread rudy
HELP. I apologize if this is too basic, but since I have next to zero documentation on it I must ask... Can you declare and use a CURSOR in a plpgsql function? The documentation I have read seems to indicate that you can, but I have not been able to get it to work. I can get a similar function to