On Thursday 19 January 2012 08:32:27 [email protected] wrote: > > Why don't you just use the built-in PostgreSQL function for that? > > SELECT aid, asid, > generate_series (asdate, afdate, INTERVAL '1 day')::date AS asdate, > acomments > FROM tbl
1) because I didn't know about it 2) because the version of postgresql I run doesn't support it. However, it does exactly what I need so thanks very much. I'll be upgrading my live server as soon as possible, but in the meantime can anyone suggest a way I can do the same thing using Postgresql 8.1 until I can evaluate 8.4 on my live systems? -- Gary Stainburn Group I.T. Manager Ringways Garages http://www.ringways.co.uk -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
