Tableless Query for Postgres

SELECT 'Anto' as name, 12 as age
UNION SELECT 'Linda', 9
UNION SELECT 'Mike', 10
SELECT  *
FROM (values ('Anto', 12),('Linda', 9), ('Mike', 10) ) AS q (name, age)
SELECT id FROM regexp_split_to_table('1,2,3,4,5,7,8,9', ',') AS id
SELECT 1 as id, pg_sleep(10)

--

--

--

Technology to write, life to grateful. Overthinking is good, only if it has the output. Fundamental is the main concern.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Going beyond automatic SVG compression with <use>

A brief history of technology

Error failed to compile jormungandr

Lessons to be Learned from Software Deprecation: Electron.

Recap of Hack-APIs Hackathon

Background Tasks, Windows Services, and More with .NET Core Hosted Services

Getting Started with LEMP: Installing Nginx, MySQL, PHP on Ubuntu 18.04 (Part 2 of 3)

Project Cega. How to participate?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Iman Tung

Iman Tung

Technology to write, life to grateful. Overthinking is good, only if it has the output. Fundamental is the main concern.

More from Medium

Getting started with streaming

Database Anomalies

SQL Fundamental

ALL ABOUT EMBEDDED AND DYNAMIC SQL