Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

select extname from pg_extension;

extname

plpgsql

btree_gist

postgis_topology

btree_gin

tablefunc

pg_trgm

pageinspect

intarray

hstore

tsm_system_rows

unaccent

postgis

select icount('{1,2,3}'::int[]);

icount

3

SELECT 'a=>1,a=>2'::hstore;

hstore

"a"=>"1"

create table my_table(row text);
insert into my_table values('hi');
SELECT * FROM my_table TABLESAMPLE SYSTEM_ROWS(100);
1 rows affected

row

hi

select ts_lexize('unaccent','Hôtel');

ts_lexize

{Hotel}