Top "Postgresql-9.4" questions

how does ordering by UUID work in PostgreSQL?

Is there any ordering guarantee on using uuid_generate_v1() on postgresql? If yes,tThe guarantees are per machine or …

postgresql sql-order-by uuid postgresql-9.4

PostgreSQL: How to SUM all attributes in a JSONB field?

I am working with Postgres 9.4. I have a JSONB field: Column │ Type │ Modifiers ─────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────── id │ integer │ not null default practice_id │ …

json postgresql postgresql-9.4 jsonb

Inserting DEFAULT value into a column when a parameter is NULL

I would like to write a stored procedure like this: CREATE OR REPLACE FUNCTION my_function(param_1 text, param_2 text …

postgresql stored-procedures plpgsql postgresql-9.4

Postgres Function to insert multiple records in two tables

create table public.orders ( orderID serial PRIMARY KEY, orderdate timestamp NOT NULL ); create table public.orderdetails ( orderdetailID serial PRIMARY KEY, …

sql database postgresql plpgsql postgresql-9.4