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
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;
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 d
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
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?
--
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