Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by newfriends1981
-
Unique rows
Hello all, please conside the following table "photo" id employee_id photo_name --------------------------------------- 1 2 abc.jpg 2 2 xyz.jpg 3 5 acd.jpg 4 2 sis.jpg 5 3...- newfriends1981
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to show coming week birthdates?
Can you PLEASE explain these queries? Because I am new to postgresql. Thank you- newfriends1981
- Post #7
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to show coming week birthdates?
Hello Fehereke and All, select * from employee,(select to_char((to_char(now(),'yyyy')||'-12-31')::date,'ddd')::int as div) foo where (to_char(birth,'ddd')::int-to_char(now(),'DDD')::int+div)%div between 0 and 6; this quere will just show the result of next week birthdays but it will not show...- newfriends1981
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
