On 01/05/21 16:14, Joel Jacobson wrote:
> or maybe even WITH like this:
>
> WITH
> year % 19 AS g ,
> year / 100 AS c,
> (c - c/4 - (8*c + 13)/25 + 19*g + 15) % 30 AS h,
> h - (h/28)*(1 - (h/28)*(29/(h + 1))*((21 - g)/11)) AS i,
> year + year/4 + i + 2 - c + c/4) % 7 AS j,
> i - j AS p,
> 3 + (p + 26)/30 AS easter_month,
> 1 + (p + 27 + (p + 6)/40) % 31 AS easter_day
> SELECT make_date(year, easter_month, easter_day)
The standard indeed has such a syntax ... not for entirely arbitrary
variables like that (at least not that I've seen) but definitely for
lexically-scoped settings of things like XMLOPTION or XMLBINARY.
Regards,
-Chap
