pgsql-sql since 2017-08-14 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

Aug. 14, 2017

Thread Author Time
Re: Always getting back a row, even with no results Achilleas Mantzios 08:24
Re: Always getting back a row, even with no results Michael Moore 17:13
Re: Updating jsonb rows Michael Moore 17:35
Re: Updating jsonb rows David G. Johnston 18:12
Re: Updating jsonb rows Michael Moore 19:33
Re: Updating jsonb rows Michael Moore 20:51

Aug. 23, 2017

Thread Author Time
how many times Campbell, Lance 18:03
Re: how many times Rob Sargent 18:15
Re: how many times Campbell, Lance 18:35
Re: how many times David G. Johnston 19:12
Re: how many times Michael Moore 21:13
Re: how many times Michael Moore 21:19

Aug. 24, 2017

Thread Author Time
Re: how many times Campbell, Lance 14:46
Determining the DATE format with libpq Sebastien FLAESCH 15:21
Re: Determining the DATE format with libpq Tom Lane 15:26
Re: Determining the DATE format with libpq Sebastien FLAESCH 15:44

Aug. 25, 2017

Thread Author Time
Re: Determining the DATE format with libpq Sebastien FLAESCH 08:13
Re: Determining the DATE format with libpq Sebastien FLAESCH 10:09

Aug. 26, 2017

Thread Author Time
Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone anand086 05:38
Re: Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone Pavel Stehule 05:50
Re: Execute format Insert sql failing with query string argument of EXECUTE is null for column with timestamp with timezone anand086 08:04

Aug. 27, 2017

Thread Author Time
Hex to Number conversion anand086 05:28
Re: Hex to Number conversion Andreas Kretschmer 07:25

Aug. 28, 2017

Thread Author Time
Function Code anand086 23:49
Re: Hex to Number conversion anand086 23:50

Aug. 29, 2017

Thread Author Time
Re: Function Code David G. Johnston 01:34

Aug. 30, 2017

Thread Author Time
Substracting Date field from integer value in another field Abdul Hameed 11:20
Re: Substracting Date field from integer value in another field Rene Romero Benavides 12:52

Aug. 31, 2017

Thread Author Time
Re: Substracting Date field from integer value in another field Abdul Hameed Kareem -X (abdukare - HCL TECHNOLOGIES LIMITED at Cisco) 03:48
autogenerated json path Viktor Bojović 21:42

Sept. 1, 2017

Thread Author Time
Re: autogenerated json path Viktor Bojović 07:59

Sept. 5, 2017

Thread Author Time
Confusion about CREATE OPERATOR syntax. Raphael Araújo e Silva 18:38

Sept. 6, 2017

Thread Author Time
Re: Confusion about CREATE OPERATOR syntax. David G. Johnston 00:31

Sept. 12, 2017

Thread Author Time
FirebirdSQL to PostgreSQL Ertan Küçükoğlu 11:31
Re: FirebirdSQL to PostgreSQL Tom Lane 12:10
Re: FirebirdSQL to PostgreSQL Ertan Küçükoğlu 20:22

Sept. 13, 2017

Thread Author Time
How could I improve a query with a function in the join clause? Daniel Franco 23:55

Sept. 14, 2017

Thread Author Time
Re: How could I improve a query with a function in the join clause? Andreas Kretschmer 01:40
Query is executing but giving error when using with shell scripting srilinux 15:58
Re: Query is executing but giving error when using with shell scripting Andreas Kretschmer 16:21
Re: Query is executing but giving error when using with shell scripting srilinux 16:27

Sept. 17, 2017

Thread Author Time
Odd sql error .. PropAAS DBA 03:01
Re: Odd sql error .. Steve Midgley 03:59

Sept. 20, 2017

Thread Author Time
SETOF any table records AS return in pgSQL functions athinivas 15:16
Re: SETOF any table records AS return in pgSQL functions David G. Johnston 16:20

Sept. 21, 2017

Thread Author Time
Single SQL to find if any record exists across several tables Ertan Küçükoğlu 12:45
Re: Single SQL to find if any record exists across several tables David G. Johnston 15:06

Sept. 22, 2017

Thread Author Time
Not able to find the postgres version in stack builder Vishwanath M.C 06:43

Sept. 27, 2017

Thread Author Time
Re: Single SQL to find if any record exists across several tables Feike Steenbergen 12:07

Sept. 29, 2017

Thread Author Time
Static variable inside PL/pgSQL (or) native C function athinivas 13:46
Re: Static variable inside PL/pgSQL (or) native C function Pavel Stehule 14:03
Re: Static variable inside PL/pgSQL (or) native C function David G. Johnston 14:04

Oct. 3, 2017

Thread Author Time
Re: Static variable inside PL/pgSQL (or) native C function athinivas 17:15
Re: Static variable inside PL/pgSQL (or) native C function Pavel Stehule 17:25

Oct. 5, 2017

Thread Author Time
Re: Re: Query is executing but giving error when using with shell scripting Feike Steenbergen 06:01
Get relation name form relids in postgresql Gourav Kumar 18:17

Oct. 6, 2017

Thread Author Time
Re: Get relation name form relids in postgresql Rene Romero Benavides 01:42
Re: Get relation name form relids in postgresql Gourav Kumar 02:48
Re: Get relation name form relids in postgresql Rene Romero Benavides 02:54
Re: Get relation name form relids in postgresql Gourav Kumar 02:55
Re: Get relation name form relids in postgresql Rene Romero Benavides 03:00
Re: Get relation name form relids in postgresql Gourav Kumar 03:04
Re: Get relation name form relids in postgresql Rene Romero Benavides 03:10

Oct. 9, 2017

Thread Author Time
Using Array in Function Günce Kaya 19:40
Re: Using Array in Function David G. Johnston 20:12
Re: Using Array in Function Günce Kaya 20:37

Oct. 10, 2017

Thread Author Time
Need Help on SQL Query ROS Didier 11:38
Re: Need Help on SQL Query hubert depesz lubaczewski 12:00
Re: Need Help on SQL Query ROS Didier 13:25
ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 ROS Didier 13:28

Oct. 11, 2017

Thread Author Time
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 Feike Steenbergen 06:20
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 - fixed ROS Didier 07:49

Oct. 14, 2017

Thread Author Time
Only insert into tables trough functions Alvin Díaz 13:36

Oct. 16, 2017

Thread Author Time
How to index encrypted colums ? ROS Didier 13:38
Re: Only insert into tables trough functions Klaus Kaisersberger 15:31
Re: How to index encrypted colums ? Klaus Kaisersberger 15:47

Oct. 17, 2017

Thread Author Time
Re: How to index encrypted colums ? ROS Didier 07:49
Re: How to get the list of tables with encrypted columns ROS Didier 07:54
Re: How to index encrypted colums ? Steve Midgley 14:14
Re: How to index encrypted colums ? ROS Didier 15:17
Re: How to index encrypted colums ? Guillaume Lelarge 15:37
Re: How to index encrypted colums ? Klaus Kaisersberger 16:26
Re: How to index encrypted colums ? Steve Midgley 16:46
Re: How to index encrypted colums ? Klaus Kaisersberger 18:33
Re: How to index encrypted colums ? Klaus Kaisersberger 18:54
Re: How to index encrypted colums ? Klaus Kaisersberger 19:18
Re: How to get the list of tables with encrypted columns Klaus Kaisersberger 20:46
Re: How to get the list of tables with encrypted columns Klaus Kaisersberger 20:49

Oct. 24, 2017

Thread Author Time
Unable to use INSERT ... RETURNING with column from other table Andreas Joseph Krogh 22:04
Re: Unable to use INSERT ... RETURNING with column from other table Peter Geoghegan 22:06
Re: Unable to use INSERT ... RETURNING with column from other table Andreas Joseph Krogh 22:49

Oct. 25, 2017

Thread Author Time
Re: Unable to use INSERT ... RETURNING with column from other table Andreas Joseph Krogh 00:21
Re: Unable to use INSERT ... RETURNING with column from other table David G. Johnston 01:56
Re: Unable to use INSERT ... RETURNING with column from other table Peter Geoghegan 02:45
Re: Unable to use INSERT ... RETURNING with column from other table Tom Lane 03:04
Re: Unable to use INSERT ... RETURNING with column from other table Andreas Joseph Krogh 21:15
Re: Unable to use INSERT ... RETURNING with column from other table Andreas Joseph Krogh 21:34

Nov. 1, 2017

Thread Author Time
join tables by nearest timestamp Brice André 05:53
Re: join tables by nearest timestamp Achilleas Mantzios 08:06
Re: join tables by nearest timestamp Achilleas Mantzios 08:11
Re: join tables by nearest timestamp Brice André 08:47
Re: join tables by nearest timestamp Brice André 13:12

Nov. 2, 2017

Thread Author Time
Re: join tables by nearest timestamp Achilleas Mantzios 07:43
Re: join tables by nearest timestamp Brice André 09:31
Re: join tables by nearest timestamp Achilleas Mantzios 14:49

Nov. 8, 2017

Thread Author Time
Problems with PARTITION BY with count() in window-func Andreas Joseph Krogh 10:17
Re: Problems with PARTITION BY with count() in window-func Andreas Joseph Krogh 13:50
Re: Problems with PARTITION BY with count() in window-func MS (direkt) 14:51

Nov. 13, 2017

Thread Author Time
md5 checksum of a previous row Iaam Onkara 06:15
Re: md5 checksum of a previous row Achilleas Mantzios 07:25
Re: md5 checksum of a previous row Iaam Onkara 07:30
Re: md5 checksum of a previous row MS (direkt) 07:31
Re: md5 checksum of a previous row Iaam Onkara 07:39
Re: md5 checksum of a previous row MS (direkt) 07:42
Re: md5 checksum of a previous row Iaam Onkara 07:47
Re: md5 checksum of a previous row Thomas Kellerer 07:49
Re: md5 checksum of a previous row Iaam Onkara 07:56
Re: md5 checksum of a previous row Achilleas Mantzios 07:57
Re: md5 checksum of a previous row Achilleas Mantzios 08:01
Re: md5 checksum of a previous row Iaam Onkara 08:01
Re: md5 checksum of a previous row Achilleas Mantzios 08:13
Re: md5 checksum of a previous row Iaam Onkara 14:11
Re: md5 checksum of a previous row Achilleas Mantzios 14:36

Nov. 14, 2017

Thread Author Time
Line number returned in Postgres Raise Exception sentence queralt 10:17

Nov. 15, 2017

Thread Author Time
Re: Line number returned in Postgres Raise Exception sentence Pavel Stehule 08:49

Nov. 20, 2017

Thread Author Time
Re: Line number returned in Postgres Raise Exception sentence queralt 12:52
Migration to pglister - Before Stephen Frost 14:33
Migration to PGLister - After Stephen Frost 14:47
Re: [ADMIN] Migration to pglister - Before Achilleas Mantzios 15:30
Re: [ADMIN] Migration to pglister - Before Stephen Frost 15:34

Nov. 22, 2017

Thread Author Time
How to use COPY command with jsonb datatype ? ROS Didier 12:04
Re: How to use COPY command with jsonb datatype ? bricklen 14:21

Nov. 23, 2017

Thread Author Time
Re: How to use COPY command with jsonb datatype ? Hector Vass 09:05
psql -c "\copy table to test.csv with CSV" - french character is wrong Emi 16:42
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong Pierre Chevalier Géologue 18:24
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong Emi 18:57

Nov. 24, 2017

Thread Author Time
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong David G. Johnston 06:28
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong Emi 14:47

Nov. 25, 2017

Thread Author Time
Roles and security nikhil raj 20:03
Re: Roles and security John R Pierce 23:15

Nov. 26, 2017

Thread Author Time
Re: Roles and security Laurenz Albe 15:18

Nov. 28, 2017

Thread Author Time
Not counting duplicates of declared pratition in OVER()-clause Andreas Joseph Krogh 17:54
Sv: Not counting duplicates of declared pratition in OVER()-clause Andreas Joseph Krogh 18:03

Dec. 7, 2017

Thread Author Time
Timestamp alculation identical to Microsoft Excel results Ertan Küçükoğlu 09:59
Re: Timestamp alculation identical to Microsoft Excel results 📎 Samed YILDIRIM 10:15
Re: Timestamp alculation identical to Microsoft Excel results Luuk 17:27

Dec. 10, 2017

Thread Author Time
window function ? Olivier Leprêtre 18:33
Re: window function ? Andreas Kretschmer 18:48

Dec. 11, 2017

Thread Author Time
Windowing ? Olivier Leprêtre 17:09
Re: Windowing ? Andreas Kretschmer 17:15
Re: Windowing ? Andreas Kretschmer 18:46

Dec. 12, 2017

Thread Author Time
FILTER clause for non-aggregate window functions Андрей Жиденков 07:54
Re: FILTER clause for non-aggregate window functions Tom Lane 15:35
Re: FILTER clause for non-aggregate window functions Андрей Жиденков 16:53

Dec. 18, 2017

Thread Author Time
XML Parsing in Postgresql Abdul Hameedk 13:50
Re: XML Parsing in Postgresql Lutz Horn 14:02
Re: XML Parsing in Postgresql Pavel Stehule 14:26

Dec. 19, 2017

Thread Author Time
SQL conformity regarding SQLSTATE Jürgen Purtz 14:14
Re: SQL conformity regarding SQLSTATE Tom Lane 15:30

Dec. 20, 2017

Thread Author Time
Re: SQL conformity regarding SQLSTATE Jürgen Purtz 10:08
Re: SQL conformity regarding SQLSTATE Simon Riggs 12:02

Dec. 21, 2017

Thread Author Time
Re: SQL conformity regarding SQLSTATE Tom Lane 01:28
Re: SQL conformity regarding SQLSTATE 📎 Jürgen Purtz 10:44
Re: SQL conformity regarding SQLSTATE Tom Lane 16:50

Dec. 22, 2017

Thread Author Time
Re: SQL conformity regarding SQLSTATE 📎 Jürgen Purtz 17:15

Dec. 25, 2017

Thread Author Time
High CPU usage in postgres servers nikhil raj 18:28
Fwd: High CPU usage in postgres servers nikhil raj 18:32
Re: High CPU usage in postgres servers Melvin Davidson 23:12

Dec. 26, 2017

Thread Author Time
Re: High CPU usage in postgres servers Michael Paquier 00:19
Oacle to Postgres migration Azimuddin Mohammed 00:28
Oracle to postgres migration Azimuddin Mohammed 00:30
Re: Oacle to Postgres migration PropAAS DBA 01:41
Re: Oracle to postgres migration John Scalia 01:51
Re: Oracle to postgres migration Vasilis Ventirozos 09:36
Re: Oracle to postgres migration Timo Myyrä 12:32
Re: Oracle to postgres migration Timo Myyrä 13:14

Dec. 29, 2017

Thread Author Time
Re: Oacle to Postgres migration Francis Santiago 21:48

Jan. 4, 2018

Thread Author Time
More optimized SQL Ertan Küçükoğlu 11:59
Sv: More optimized SQL Andreas Joseph Krogh 13:27

Jan. 13, 2018

Thread Author Time
Alternative SQL Ertan Küçükoğlu 22:26

Jan. 18, 2018

Thread Author Time
Ajuda - insert into select com variavel Danilo 01:15
Re: Ajuda - insert into select com variavel Iuri Sampaio 17:01
Re: Ajuda - insert into select com variavel Danilo Bruneli 17:16
Re: Ajuda - insert into select com variavel Iuri Sampaio 17:24

Jan. 25, 2018

Thread Author Time
nth_value and row_number in a partition Olivier Leprêtre 18:30
Re: nth_value and row_number in a partition David G. Johnston 18:43
RE: nth_value and row_number in a partition Olivier Leprêtre 19:49
Re: nth_value and row_number in a partition David G. Johnston 19:57
Re: nth_value and row_number in a partition Martin Stöcker 20:12
RE: nth_value and row_number in a partition Olivier Leprêtre 20:52

Jan. 26, 2018

Thread Author Time
Re: nth_value and row_number in a partition MS (direkt) 07:31
RE: nth_value and row_number in a partition Olivier Leprêtre 16:56
Re: nth_value and row_number in a partition Martin Stöcker 17:04

Feb. 2, 2018

Thread Author Time
search inside partitions Olivier Leprêtre 09:00
help defining a stored procedure that returns a record or an array using SELECT INTO Luca Ferrari 09:21
Re: help defining a stored procedure that returns a record or an array using SELECT INTO Pavel Stehule 09:42
Re: search inside partitions Torsten Grust 11:01
Re: search inside partitions Torsten Grust 11:20
RE: search inside partitions Olivier Leprêtre 13:44

Feb. 9, 2018

Thread Author Time
functions allowed in CHECK constraints Achilleas Mantzios 08:37

Browse Archives

Prev | Next