 |
.. (לתיקייה המכילה) | |
Where can we find the PostgreSQL documentations?
| Follow the attached link. | |
| קישור: Link: Ссылка: وصلة: | http://www.postgresql.org/docs/ |
How should we express a constant date within a query?
|
You can use the ISO 8601 standard where: `19990108' is January 8, 1999 | |
| קישור: Link: Ссылка: وصلة: | http://www.postgresql.org/docs/current/static/datatype-datetime.html |
Can we use arithmetic operators on a date field?
|
Yes. You can read about it in the attached link. Note that you can spare the {Date\Timestamp} keywords. | |
| קישור: Link: Ссылка: وصلة: | http://techdocs.postgresql.org/techdocs/faqdatesintervals.php |
Should we print a newline character ('\n') after printing NONE or ILL_PARAMS?
|
No. These constants already contain the '\n' character. |
On what occasions should we print the constants ILL_PARAMS and NONE?
|
NONE - whenever you get an empty answer. ILL_PARAMS - whenever you cannot execute a command due to illegal parameters. |
CoAuthorsRel command: is it possible that author1==author2 and if so, how should we handle this case?
| You can ignore this option. |
Recommend command: what set determines the products quantities?
|
You should calculate the quantities according to last month orders. Last month is defined in the assignment text. |
ExecutiveReport Command: least ordered item refers to?
|
Of all ordered items the one with minimal ordered quota. |
What is Bus Error? How can we solve it?
|
The bus error notification indicates anomalous condition on the processor's bus. It is usually due to invalid address alignment, accessing a physical address that does not correspond to any device, or some other device-specific hardware error. Inorder to solve it: try to find duplicate calls for PQclear, insufficient memory allocation (too small buffers) and such. |
Recommend:In the follwoing example of given ids & quantities
( first field is id): (21 3) (22 5) (51 1) (23 1) What should we print?
|
21 22 23 |
CoAuthrosRel: do all authors in the series have to be the authors of the same book ?
| No. |
How can we eliminate "multi lines" warning messages?
|
Break the strings, using qoutes, according to screen lines. Example: sprintf(cmd,"SELECT XXX FROM " /*<---!*/ "Table1,Table2 WHERE " /*<---!*/ "P1=100 AND .."); |
RecommendByHistory:
If someone bought the same product 3 times, should we count it
as 1 or 3 in the history size calculation?
| History is a set of ids therefore the size of the history is the amount of ids in that set. Quantities are not relevant here. |