On Thursday 19 January 2012 08:32:27 hari.fu...@gmail.com 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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
