The last day of 2015

本文回顾了作者2015年的工作经历,包括业务库维护与优化、负责新猎头项目的开发、参与新招聘站点的开发、小型Web聊天项目的开发等,并表达了对于个人英语水平提升及未来发展的期待。

Today is the last day of 2015. Also I first wrote blog.  Because I writing is poor,  finally I decided to write with poor English.

This year is very fast.I remember this time to work overtime to 11:00 in company last year, then waited a long time for the car  and  I was waiting for the bus welcome New Year.

Fortunately, this is not too much overtime this year.First of all I say the content of work and acquisition.

1、Business library routine maintenance and optimization(Business library has many historical issues,I hope that more useful under my leadership)

2、Responsible for the development project of the 'new headhunter'

3、Involved in Development of the new recruiting station(It's appearance has improved a lot and adds the concept of talent currency.Later we will to improve it's funciton and structure.I believe it will bring more customers)

4、Development of small projects about webchat(I need to put in more effort to understand and learn more knowledge)

5、Other(Including merge code、assignments....)

We are using zentao to assign tasks and to carry out.I feel there are endless task this year, and did't go to learn new things.I have been doing repetitive things and fell heart tired.

I applied for English classes at Shenzhen University.I like English but it's poor.Occasionally listen to Japanese lesson.I hope that  I  went to Japan with students after graduation .so,I need earn more money.

Today,Manager talked to me about year end of matter. also talked me that I don't have the change to promotion just to label me with 'A' to rise salary.I know that manager is try his best for us.

Off work,Just to say this today,I hope I can make more progress in new year.To meet all difficulties with smile微笑.

 

 

 

在PostgreSQL (PG) 中遇到 "day must be between the first and last day of the month" 这样的错误通常是由于你在日期操作中尝试插入无效的日期范围。例如,如果你试图插入一个月的第32天或者0日(即非存在的日子)。 为了解决这个问题,你可以按照以下步骤检查并修复: 1. **数据验证**:确保用户输入的数据(如果通过用户界面获取)在合理的范围内,比如使用正则表达式检查日期格式是否正确,并且确实在一个月内。 ```sql CREATE OR REPLACE FUNCTION validate_date(date_column date) RETURNS boolean AS $$ BEGIN RETURN EXTRACT(DAY FROM $1) BETWEEN 1 AND 31; END; $$ LANGUAGE plpgsql; -- 使用函数检查输入值 SELECT validate_date(your_date_column); ``` 2. **存储过程或触发器**:如果你在数据库层面需要这种约束,可以创建一个存储过程或者触发器,在插入新记录之前自动检查日期是否有效。 ```sql CREATE OR REPLACE FUNCTION check_month_boundary(p_date date) RETURNS trigger AS $$ BEGIN IF NOT (p_date >= '2000-01-01' AND p_date <= '2999-12-31' AND EXTRACT(DAY FROM p_date) BETWEEN 1 AND 31) THEN RAISE EXCEPTION 'Invalid date: Day must be between 1 and 31'; END IF; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER check_date_constraint BEFORE INSERT ON your_table FOR EACH ROW EXECUTE PROCEDURE check_month_boundary(NEW.your_date_column); ``` 3. **应用事务**:在插入操作前开启事务,如果插入失败则回滚事务。 ```sql BEGIN; INSERT INTO your_table (your_date_column) VALUES ('your_date'); IF NOT EXISTS (SELECT * FROM your_table WHERE your_date_column = 'your_date') THEN ROLLBACK; RAISE 'Day out of range'; ELSE COMMIT; END IF; ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值