From: | Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: inserting via "on insert" rule |
Date: | 2003-09-03 20:37:27 |
Message-ID: | 3F565107.8090007@physik.uni-erlangen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Peter Eisentraut wrote:
>Andreas Fromm writes:
>
>
>
>>I was thinking of defining a view "users" over "persons" which would let
>>me retrive the list of useres. But How would I implement the rule for
>>insertiung users? I tryed the following but NEW is not known where I
>>want to use it:
>>
>>CREATE VIEW users AS
>> SELECT * FROM persons WHERE is_user(person.id) = TRUE;
>>
>>CREATE RULE insert_on_users AS ON INSERT
>> TO users DO INSTEAD
>> INSERT INTO persons SELECT * FROM NEW;
>>
>>
>
>You can write
>
>... DO INSTEAD INSERT INTO persons VALUES (NEW.col1, NEW.col2, ...);
>
>
>
Yes, but the advantage of the select would be that I could do a SELECT
.. FROM .. WHERE , or how can I perform a checking of the data before
insertion?
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Josué Maldonado | 2003-09-03 20:43:18 | Re: Inquiry From Form [pgsql] |
Previous Message | Peter Eisentraut | 2003-09-03 20:13:33 | Re: How many memory size takes numeric(3,0) ? |