 |
.. (לתיקייה המכילה) | |
In pyramidBonus function, can we create a temporary table in our database or as an array in C? | |
|
NO! If the company exists, the whole update must be performed in one single "UPDATE" command. Reminder (for all functions): You must not create tables or views, and must not process the data in C code. |
Can we read field(s) from one query and pass it(them) as parameter(s) to another query? | |
|
NO! If function's parameters are valid, a single query must be sent and the whole result table must be printed. |
In forbidMembership, if the record of [user,company] already exists, must we add the same record one more time? | |
| No. Every record in "forbidden" table may appear at most once. |
Do we have to do all parameter checks of a function in a SINGLE query? | |
|
No. If it's more convenient for you, you may send different queries for each error case. |
In question 4, must both the insertion to a forbidden list and the deletion from members' list be done in one SQL command? | |
| No. there should be two separate commands. |
The program compiles but doesn't run. What do we miss? | |
| You probably need to set the environment variable LD_LIBRARY_PATH, as described in slide 5 in PostgreSQL presentation. |
Should we submit the printout of the code? | |
| No, there is absolutely no need to. Save your time and trees. |