Re: Help with a postgreSQL-query

1998-02-06 Thread office
PLEASE REMOVE THE ADDRESSES [EMAIL PROTECTED] [EMAIL PROTECTED] or any freetech-mall.com address !! DO IT NOW I DONT WANT TO READ THIS AND I NEVER wanted ! STefan GAertner -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word unsubscribe to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL

Help with a postgreSQL-query

1998-02-04 Thread Johann Spies
Hallo, I am using pygresql as an interface to postgres. I want to get a list of people who's birthday it is today. Which is the best way to do it. The following code works, but it is very slow and does 101 queries. Is there a way to put this into a single query? If I would like to know which

Re: Help with a postgreSQL-query

1998-02-04 Thread Dave Mitchell
This sounds more like an SQL question to me. I don't have postgres, but on informix there's a day() function for dates so I can do this: SELECT * FROM agenda_items WHERE day(itemdate)=15; (where itemdate is a DATETIME field) -dave m.