var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is It Possible To Make a Query That Autogenerate The Data?
Hi to All,
i make a query in a file :
then I executed the query by the command
SELECT * FROM orders WHERE week=6;
Is it possible to make a psql function that autogenerates the week number(1-53) taking it from the system(O.S)?
If yes, which will be the sintax, and how tho execute the function?
Tanks in advance.
More details in the manual: http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
extract(week from current_date)
have You the same attention X100, to every Your question.
Tanks again for Your promt replay.