On 3/9/10 1:04 PM, drugh10 wrote: > My thought was to write a piece of code that could take the device_id, start, > and end dates as arguments, then perform a query something like the one above > for each day between start and end, providing the availability number for > each day as output. I was having problems seeing how to 1) create variables > to pass start/end dates and increment thru the range, and 2) how to provide > loop control to execute and enclosed query using the variables. >
No, I'm pretty sure you'll need a scripting language to do this. pgAdmin wouldn't support this, AFAIK. But I'm not a power-user of pgAdmin, so someone else should feel free to jump in if I'm wrong. -- Christopher -- ================================= Christopher L. Sweeney Director of Software Development Dartware, LLC +1 603 643-9600 x104 http://dartware.com/ ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
