Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
postgresql select test
drop table if exists form_translations; create table form_translations (id integer, translations jsonb, form_id integer); insert into form_translations values (1, '{"ru": {"tooltip": "Моя подсказка 1", "notation": "Мое обозначение 1"}, "en": {"tooltip": "My tooltip 1", "notation": "My notation 1"}}', 3), (2, '{"ru": {"tooltip": "Моя подсказка 2", "notation": "Мое обозначение 2"}, "en": {"tooltip": "My tooltip 2", "notation": "My notation 2"}}', 2), (3, '{"ru": {"tooltip": "Моя подсказка 3", "notation": "Мое обозначение 3"}, "en": {"tooltip": "My tooltip 3", "notation": "My notation 3"}}', 1); drop table if exists forms; create table forms (id integer, summary text); insert into forms values (1, 'Form 1'), (2, 'Form 2'), (3, 'Form 3'); drop table if exists users; create table users (id integer, name text, locale text); insert into users values (1, 'Archi', 'ru'), (2, 'Bob', 'en'), (3, 'Coby', 'en'); select * from form_translations; select * from forms; select * from users;
run
|
edit
|
history
|
help
0
Conditional Cross Join - Why doesn't this work on the 'ON' clause?
Select the latest id from last week from each different contact without repeating barcodes .....
Assignment 1(SET A)
Pedido_Insert_Into
prec
Finale8E9237394
Ecommerce Website Analysis by SQL
PostreSQL: Full Outer Join
PostgreSQL aggregate JSON recordset keys by row
2