planet.postgresql.org planet.postgresql.org

David Fetter: You don't need PL/pgsql!

You don't need PL/pgsql to create functions that do some pretty sophisticated things. Here's a function written entirely in SQL that returns the inverse cumulative distribution function known in Microsoft Excel™ circles as NORMSINV. CREATE OR REPLACE FUNCTION normsinv(prob float8)RETURNS float8STRICTLANGUAGE SQLAS $$WITH constants(a,b,c,d,p_low, p_high) AS ( VALUES( ARRAY[-3.969683028665376e+01::float8 ,...

Magic Leap CEO: We’re dead serious about the ‘Magicverse’

Rony Abovitz, CEO of Magic Leap, talks about the Magicverse like it’s a real thing. That’s because it is part of the visionary manifesto, of which the Magic Leap One augmented reality glasses are only a part. In an exclusive interview with GamesBeat, Abovitz said his company is working with partners to build the Magicverse, which is his vision for a positive version of The Matrix, the Metaverse, the Oasis, and many other science...