On Mon, Dec 20, 2004 at 09:56:35AM +0200, Vitaly Belman wrote:
I have two tables. Books and Book_Authors (which links between
book_id and author_id).
Is there a third table, perhaps Authors?
Book_authors has a foreign key on book_id to the Books table. On key
violation it is set to delete
Hi All!
I need to make function which emulates table and returns setof columns
of this table
for example, i'm making query: SELECT * FROM my_table(user_id)
and function
CREATE OR REPLACE FUNCTION my_table (integer)
RETURNS setof text
AS '
DECLARE
check_date date;
max_date date;
r
On Mon, Dec 20, 2004 at 04:31:59PM +0300, ON.KG wrote:
I need to make function which emulates table and returns setof columns
of this table
Please start a new thread with a descriptive subject -- the message
you posted was a followup to a thread covering a different topic.
--
Michael Fuhr
I noticed that when you do a constraint and tell it cascade on
delete, it will do so only AFTER that the source is deleted. Can I
tell it somehow to cascade BEFORE the source is gone?
--
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end
On Sun, Dec 19, 2004 at 03:20:19PM +0200, Vitaly Belman wrote:
I noticed that when you do a constraint and tell it cascade on
delete, it will do so only AFTER that the source is deleted. Can I
tell it somehow to cascade BEFORE the source is gone?
What problem are you trying to solve?
--
It's a bit complex.
I have two tables. Books and Book_Authors (which links between
book_id and author_id).
Book_authors has a foreign key on book_id to the Books table. On key
violation it is set to delete the rows (if a book is deleted, it
should't be linked to any authors).
In Book_Authors I