My Favorite PostgreSQL 18 Feature: Virtual Generated Columns

Comments (1)

saltcured · 43s ago

Aside from the SQL syntax, what is the difference between this and the longstanding virtual column feature, where you can define a function that takes the table's record type as input and return a scalar? PostgreSQL already let you use table.funcname as a virtual column, as I recall.

We should have the ability to run any code we want on hardware we own (hugotunius.se)

Cognitive load is what matters (github.com)

NPM debug and chalk packages compromised (aikido.dev)

I didn't bring my son to a museum to look at screens (sethpurcell.com)

I ditched Docker for Podman (codesmash.dev)

30 minutes with a stranger (pudding.cool)

996 (lucumr.pocoo.org)

Show HN: Term.everything – Run any GUI app in the terminal (github.com)

Next.js is infuriating (blog.meca.sh)

Germany is not supporting ChatControl – blocking minority secured (digitalcourage.social)

The MacBook has a sensor that knows the exact angle of the screen hinge (twitter.com)

Show HN: I recreated Windows XP as my portfolio (mitchivin.com)

Charlie Kirk killed at event in Utah (nbcnews.com)

Anthropic agrees to pay $1.5B to settle lawsuit with book authors (nytimes.com)

Signal Secure Backups (signal.org)

Using Claude Code to modernize a 25-year-old kernel driver (dmitrybrant.com)

iPhone Air (apple.com)

Google can keep its Chrome browser but will be barred from exclusive contracts (cnbc.com)

I replaced Animal Crossing's dialogue with a live LLM by hacking GameCube memory (joshfonseca.com)

Pontevedra, Spain declares its entire urban area a "reduced traffic zone" (greeneuropeanjournal.eu)

We all dodged a bullet (xeiaso.net)

Stripe Launches L1 Blockchain: Tempo (tempo.xyz)

Mistral raises 1.7B€, partners with ASML (mistral.ai)

Chat Control Must Be Stopped (privacyguides.org)

“This telegram must be closely paraphrased before being communicated to anyone” (history.stackexchange.com)

New Mexico is first state in US to offer universal child care (governor.state.nm.us)

Almost anything you give sustained attention to will begin to loop on itself (henrikkarlsson.xyz)

Where's the shovelware? Why AI coding claims don't add up (mikelovesrobots.substack.com)

Google AI Overview made up an elaborate story about me (bsky.app)

Claude Code: Now in Beta in Zed (zed.dev)

iPhone dumbphone (stopa.io)

Eternal Struggle (yoavg.github.io)

ICE is using fake cell towers to spy on people's phones (forbes.com)

KDE launches its own distribution (lwn.net)

Claude now has access to a server-side container environment (anthropic.com)

I'm absolutely right (absolutelyright.lol)

LLM Visualization (bbycroft.net)

Court rejects Verizon claim that selling location data without consent is legal (arstechnica.com)

Notes on Managing ADHD (borretti.me)

Serverless Horrors (serverlesshorrors.com)

MIT Study Finds AI Use Reprograms the Brain, Leading to Cognitive Decline (publichealthpolicyjournal.com)

No adblocker detected (maurycyz.com)

E-paper display reaches the realm of LCD screens (spectrum.ieee.org)

The maths you need to start understanding LLMs (gilesthomas.com)

AI surveillance should be banned while there is still time (gabrielweinberg.com)

Wikipedia survives while the rest of the internet breaks (theverge.com)

Fil's Unbelievable Garbage Collector (fil-c.org)

Anthropic raises $13B Series F (anthropic.com)

We already live in social credit, we just don't call it that (thenexus.media)

Google: 'Your $1000 phone needs our permission to install apps now' [video] (youtube.com)

My Favorite PostgreSQL 18 Feature: Virtual Generated Columns

Comments (1)