pgsql-sql since 2015-12-17 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Dec. 17, 2015

Thread Author Time
Re: Help with complicated query (total SQL newb!) Adrian Klaver 00:19
Re: cant get what I want from array_to_json (simple) Michael Moore 18:25

Dec. 18, 2015

Thread Author Time
array of composite type Michael Moore 00:03
Re: array of composite type David G. Johnston 00:13

Dec. 29, 2015

Thread Author Time
Stucks in the middle Yevgeny 11:11
Re: Stucks in the middle Steve Midgley 18:23
Re: Stucks in the middle Adrian Klaver 18:24

Dec. 30, 2015

Thread Author Time
question on row level security Tim Dudgeon 16:58
Re: question on row level security David G. Johnston 17:19
Re: question on row level security Tim Dudgeon 17:28
Re: question on row level security Adrian Klaver 17:28
Re: question on row level security Joe Conway 17:32
Re: question on row level security Karsten Hilbert 17:37
Re: question on row level security Tim Dudgeon 17:37
Re: question on row level security David G. Johnston 17:42

Jan. 5, 2016

Thread Author Time
plv8 installation problem Belju Paul 08:56
Re: plv8 installation problem Adrian Klaver 15:59
Re: [SQL] plv8 installation problem Adrian Klaver 17:09

Jan. 6, 2016

Thread Author Time
Re: [SQL] plv8 installation problem Adrian Klaver 00:34

Jan. 7, 2016

Thread Author Time
public synonym Eugene Yin 20:17
To get the column names, data types, and nullables of tables in the schema owned by MASTER_USER Eugene Yin 20:22
Re: public synonym [email protected] 20:27
Re: To get the column names, data types, and nullables of tables in the schema owned by MASTER_USER Joe Conway 20:46
Re: public synonym Adrian Klaver 22:03

Jan. 8, 2016

Thread Author Time
UPDATE without naming columns Michael Moore 01:09

Jan. 9, 2016

Thread Author Time
Re: Stucks in the middle Yevgeny 21:46
Re: Stucks in the middle bricklen 21:50

Jan. 10, 2016

Thread Author Time
BLOBs Eugene Yin 06:20
Re: BLOBs Tom Lane 07:12

Jan. 11, 2016

Thread Author Time
Re: BLOBs Eugene Yin 00:37
Re: BLOBs Andreas Joseph Krogh 10:09
Re: BLOBs 📎 Eugene Yin 15:37
Re: BLOBs Andreas Joseph Krogh 17:48
Very cool 9.5 feature Michael Moore 18:47

Jan. 12, 2016

Thread Author Time
Re: BLOBs 📎 Eugene Yin 01:32
Re: BLOBs Andreas Joseph Krogh 07:09

Jan. 13, 2016

Thread Author Time
BYTEA vs BLOB Eugene Yin 01:45
best way sync data from Oracle to PostgreSQL? Michael Moore 16:37
Re: best way sync data from Oracle to PostgreSQL? Adrian Klaver 17:48

Jan. 14, 2016

Thread Author Time
Re: BYTEA vs BLOB John DeSoi 16:00

Jan. 15, 2016

Thread Author Time
remove null values from json Michael Moore 20:24
strip values from json doc Michael Moore 21:43

Jan. 16, 2016

Thread Author Time
Re: BYTEA vs BLOB Eugene Yin 16:08

Jan. 17, 2016

Thread Author Time
Re: BYTEA vs BLOB Andreas Joseph Krogh 15:01
tablespace Eugene Yin 16:28
Re: BYTEA vs BLOB 📎 Eugene Yin 16:56
Re: BYTEA vs BLOB Andreas Joseph Krogh 17:01
Re: BYTEA vs BLOB 📎 Eugene Yin 17:37
Re: BYTEA vs BLOB Andreas Joseph Krogh 17:42
Re: BLOBs 📎 Eugene Yin 19:26
BYTEA Eugene Yin 19:33
Re: BYTEA Adrian Klaver 20:29
Re: BLOBs Andreas Joseph Krogh 22:08
Re: BYTEA Andreas Joseph Krogh 22:09
Re: BYTEA Thomas Kellerer 22:13
Re: BLOBs Thomas Kellerer 22:17

Jan. 18, 2016

Thread Author Time
Re: BYTEA Cat 00:25
Re: BYTEA Karsten Hilbert 10:05
Re: BYTEA Andreas Joseph Krogh 13:06
Re: BLOBs Andreas Joseph Krogh 13:08
Re: BYTEA 📎 Eugene Yin 15:40
Re: BYTEA Andreas Joseph Krogh 15:50
Re: BYTEA 📎 Eugene Yin 16:30
Re: BYTEA Andreas Joseph Krogh 17:26

Jan. 19, 2016

Thread Author Time
Re: remove null values from json Pavel Stehule 18:09
filtering columns in function David Ford 19:59
Re: filtering columns in function David G. Johnston 20:21

Jan. 28, 2016

Thread Author Time
PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 06:31
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Adrian Klaver 16:27
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 16:33
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Adrian Klaver 16:42
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 16:53
insert a text file into a variable in order to insert into a bytea column Arthur Lewis 18:10
Re: insert a text file into a variable in order to insert into a bytea column Adrian Klaver 18:20
Re: insert a text file into a variable in order to insert into a bytea column Arthur Lewis 18:46
Re: insert a text file into a variable in order to insert into a bytea column Adrian Klaver 20:08
Re: insert a text file into a variable in order to insert into a bytea column Arthur Lewis 21:08
Re: insert a text file into a variable in order to insert into a bytea column David G. Johnston 21:57
Re: insert a text file into a variable in order to insert into a bytea column Arthur Lewis 22:36
Re: insert a text file into a variable in order to insert into a bytea column Adrian Klaver 23:01

Jan. 29, 2016

Thread Author Time
GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 00:05
Re: GROUP BY overlapping (tsrange) entries Michael Moore 01:02
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 01:11
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 01:43
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 16:45
Re: GROUP BY overlapping (tsrange) entries David G. Johnston 16:59
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 17:30
Re: GROUP BY overlapping (tsrange) entries Michael Moore 18:17
Re: GROUP BY overlapping (tsrange) entries David G. Johnston 19:23
Re: GROUP BY overlapping (tsrange) entries Misa Simic 19:33
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 23:34

Jan. 30, 2016

Thread Author Time
Re: GROUP BY overlapping (tsrange) entries Michael Moore 00:20
Re: GROUP BY overlapping (tsrange) entries David G. Johnston 00:34
Re: GROUP BY overlapping (tsrange) entries Misa Simic 12:45
Re: GROUP BY overlapping (tsrange) entries Andreas Joseph Krogh 13:22

Feb. 3, 2016

Thread Author Time
Replication Jürgen Purtz 18:46
update without SET ? Michael Moore 18:49
Re: update without SET ? Hector Vass 20:59
Re: update without SET ? David G. Johnston 21:51
Re: update without SET ? Michael Moore 22:09
Re: update without SET ? David G. Johnston 22:20
Re: Replication Steve Midgley 22:59
Re: update without SET ? Michael Moore 23:09
Re: update without SET ? David G. Johnston 23:35

Feb. 4, 2016

Thread Author Time
Re: update without SET ? Michael Moore 00:49
Re: update without SET ? David G. Johnston 01:44
Create db fails using utility tool Shashank Dutt Jha 07:23
Q: documentation bug ? Karsten Hilbert 10:53
Re: Q: documentation bug ? Karsten Hilbert 10:56
Re: [GENERAL] Q: documentation bug ? Vik Fearing 11:00
Re: [SQL] Q: documentation bug ? Karsten Hilbert 11:05
Re: [GENERAL] Q: documentation bug ? Tom Lane 16:01
Re: update without SET ? Michael Moore 16:19
Re: update without SET ? David G. Johnston 16:31
Re: Create db fails using utility tool Adrian Klaver 16:40
Re: Create db fails using utility tool Shashank Dutt Jha 17:45
Re: [SQL] Q: documentation bug ? Fabrízio de Royes Mello 17:56
Re: Create db fails using utility tool Adrian Klaver 18:04
Re: update without SET ? Michael Moore 19:19

Feb. 5, 2016

Thread Author Time
Re: Create db fails using utility tool Shashank Dutt Jha 04:15
Re: Create db fails using utility tool Adrian Klaver 06:08

Feb. 9, 2016

Thread Author Time
Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 04:29
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Tom Lane 05:00
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:21
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Rob Sargent 05:33
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 05:47
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:48
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 05:50
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 05:53
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Rob Sargent 05:57
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:00
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Adrian Klaver 06:01
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:03
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Venkatesan, Sekhar 06:14
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. David G. Johnston 06:21
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Thomas Kellerer 06:43
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Mike Sofen 12:41
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Stuart 16:14

Feb. 10, 2016

Thread Author Time
Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar 06:36
Re: Need documentation for PostgreSQL Replication support. Thomas Kellerer 06:52
inserting json content from a file into table column Shashank Dutt Jha 15:10
Re: inserting json content from a file into table column Adrian Klaver 15:22
Re: inserting json content from a file into table column Shashank Dutt Jha 16:01
Re: inserting json content from a file into table column Adrian Klaver 16:34
Re: inserting json content from a file into table column David G. Johnston 16:50

Feb. 11, 2016

Thread Author Time
Re: inserting json content from a file into table column Shashank Dutt Jha 06:11

Feb. 14, 2016

Thread Author Time
PostgreSQL: Inserting NULL values adds empty string. Venkatesan, Sekhar 13:13
Re: [ODBC] PostgreSQL: Inserting NULL values adds empty string. Adrian Klaver 16:48
Re: PostgreSQL: Inserting NULL values adds empty string. Venkatesan, Sekhar 18:08
Re: PostgreSQL: Inserting NULL values adds empty string. Thomas Kellerer 18:21
Re: PostgreSQL: Inserting NULL values adds empty string. Adrian Klaver 18:36

Feb. 15, 2016

Thread Author Time
Re: PostgreSQL: Inserting NULL values adds empty string. Inoue, Hiroshi 11:53

Feb. 16, 2016

Thread Author Time
refer function name by a variable in the function body Suresh Raja 15:41
Re: [SQL] refer function name by a variable in the function body hubert depesz lubaczewski 16:15

Feb. 17, 2016

Thread Author Time
Re: refer function name by a variable in the function body amulsul 12:54

Feb. 26, 2016

Thread Author Time
Query about foreign key details for php framework David Binney 00:38
Re: Query about foreign key details for php framework Adrian Klaver 00:49
Re: Query about foreign key details for php framework David Binney 00:56
Re: Query about foreign key details for php framework Adrian Klaver 01:05
Re: Query about foreign key details for php framework David Binney 01:36
Re: Query about foreign key details for php framework Adrian Klaver 03:11
Re: Query about foreign key details for php framework David Binney 03:19
Re: Query about foreign key details for php framework Stuart 05:18
Re: Query about foreign key details for php framework David Binney 07:29
Re: Query about foreign key details for php framework Stuart 09:13
Re: Query about foreign key details for php framework David Binney 09:45
Subselect left join / not exists() Desmond Coertzen 11:17
Re: Query about foreign key details for php framework Stuart 12:22
Re: Query about foreign key details for php framework Stuart 12:28
Re: Subselect left join / not exists() David G. Johnston 14:53
Re: Subselect left join / not exists() Tom Lane 15:00
Re: Query about foreign key details for php framework Adrian Klaver 15:15
Re: Query about foreign key details for php framework David Binney 18:47
Re: Subselect left join / not exists() Desmond Coertzen 19:54
Re: Subselect left join / not exists() Rob Sargent 20:35
Re: Query about foreign key details for php framework Adrian Klaver 21:33

Feb. 27, 2016

Thread Author Time
Re: Query about foreign key details for php framework David Binney 04:29
Re: Query about foreign key details for php framework David G. Johnston 07:56
Re: Query about foreign key details for php framework Adrian Klaver 15:20

Feb. 28, 2016

Thread Author Time
Re: Query about foreign key details for php framework Stuart 09:30
Re: Query about foreign key details for php framework David Binney 23:42
Re: Query about foreign key details for php framework David Binney 23:55

Feb. 29, 2016

Thread Author Time
Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar 03:58
Re: Need documentation for PostgreSQL Replication support. Venkatesan, Sekhar 04:01
Re: Need documentation for PostgreSQL Replication support. Thomas Kellerer 07:29
Re: Query about foreign key details for php framework Stuart 08:28
Re: Query about foreign key details for php framework Adrian Klaver 14:58
Re: Subselect left join / not exists() Desmond Coertzen 17:17

March 1, 2016

Thread Author Time
Re: Need documentation for PostgreSQL Replication support. Tsunakawa, Takayuki 03:48
Re: Subselect left join / not exists() 📎 Desmond Coertzen 10:24

March 2, 2016

Thread Author Time
Re: Query about foreign key details for php framework David Binney 01:38
Re: Query about foreign key details for php framework Adrian Klaver 14:56
Re: Query about foreign key details for php framework David Binney 23:42
Re: Query about foreign key details for php framework Adrian Klaver 23:45

March 3, 2016

Thread Author Time
Re: Query about foreign key details for php framework David Binney 01:59
Re: Query about foreign key details for php framework Adrian Klaver 14:17

March 9, 2016

Thread Author Time
How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict) Alexandru Lazarev 12:18
Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict) Alexandru Lazarev 19:39
Re: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict) David G. Johnston 20:03
Re: Fwd: How does PostgreSQL serializable transaction works? (SELECT/UPDATE vs INSERT conflict) Jeff Janes 20:37

Browse Archives

Prev | Next