On Tuesday 21 August 2012 12:14:53 Jasen Betts wrote: > > What's the best way to do this? > > CASE looks good. > > > I know it's a quite open question but I'm interested to hear different > > responses > > "date_b" on line three, is that a typo? if not how am i to interpret > it?
The table contains date_1, date_2 and date_3. The resulting view needs to contain date_1, date_2, date_3, date_a and date_b where date_a and date_b are calculated based on the first three (plus a text field). -- 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
