Re: Help with a postgreSQL-query
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 PROTECTED] .
Help with a postgreSQL-query
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 people was born on say the 15th of any month, how can I query that without having to send 12*100 queries to postgreSQL? --- from pgext import * from pgtools import * from time import time def bidlys(pgcnx): t = time.time() jaar, maand, dag = time.localtime(t)[0:3] datumlys = [] for i in range(jaar-100,jaar+1): datum = '%02d.%02d' + '.%02d' dat = datum%(dag,maand,i) datumlys.append(dat) print veldlys = ['noemnaam', 'van', 'geboortedatum', 'adres1'] lys = [] for d in datumlys: s = SELECT noemnaam, van, geboortedatum, adres1 from lidmate, besoekpunt where (besoekpunt.nommer = bpnommer and geboortedatum = '%s')%d bidvir = pgcnx.query(s) if not bidvir.getresult() == []: for item in bidvir.getresult(): lys.append(item) display(veldlys,lys) cnx = connect() wys = bidlys(cnx) Johann Spies [EMAIL PROTECTED] Windsorlaan 19 Pietermaritzburg 3201 Suid Afrika (South Africa) Tel/Faks Nr. +27 331-46-1310 -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word unsubscribe to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL PROTECTED] .
Re: Help with a postgreSQL-query
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. On Wed, 4 Feb 1998, Johann Spies wrote: 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 people was born on say the 15th of any month, how can I query that without having to send 12*100 queries to postgreSQL? --- from pgext import * from pgtools import * from time import time def bidlys(pgcnx): t = time.time() jaar, maand, dag = time.localtime(t)[0:3] datumlys = [] for i in range(jaar-100,jaar+1): datum = '%02d.%02d' + '.%02d' dat = datum%(dag,maand,i) datumlys.append(dat) print veldlys = ['noemnaam', 'van', 'geboortedatum', 'adres1'] lys = [] for d in datumlys: s = SELECT noemnaam, van, geboortedatum, adres1 from lidmate, besoekpunt where (besoekpunt.nommer = bpnommer and geboortedatum = '%s')%d bidvir = pgcnx.query(s) if not bidvir.getresult() == []: for item in bidvir.getresult(): lys.append(item) display(veldlys,lys) cnx = connect() wys = bidlys(cnx) Johann Spies [EMAIL PROTECTED] Windsorlaan 19 Pietermaritzburg 3201 Suid Afrika (South Africa) Tel/Faks Nr. +27 331-46-1310 -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word unsubscribe to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL PROTECTED] .