pgsql-sql since 2017-06-02 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

June 2, 2017

Thread Author Time
Re: YNT: Re: Can the result sets produced in SQL procedures be left open for the use of the calling program? Adrian Klaver 00:07
Using bind variable within BEGIN END anand086 00:24
Re: Using bind variable within BEGIN END David G. Johnston 00:31
Re: Using bind variable within BEGIN END Rob Sargent 00:59
Re: Using bind variable within BEGIN END anand086 01:35
Database views metadata always nullable columns basuraspam - 14:11
Re: Database views metadata always nullable columns Tom Lane 14:21
Re: Database views metadata always nullable columns basuraspam - 15:33
Re: Database views metadata always nullable columns David G. Johnston 15:59
Re: Database views metadata always nullable columns Tom Lane 16:07
Re: Using bind variable within BEGIN END anand086 17:29
Re: Using bind variable within BEGIN END David G. Johnston 18:21
Re: Using bind variable within BEGIN END David G. Johnston 18:27
YNT: Re: Using bind variable within BEGIN END gulsumramazanoglu 18:35
YNT: Re: Using bind variable within BEGIN END gulsumramazanoglu 18:38
Re: Using bind variable within BEGIN END David G. Johnston 18:57
Re: Using bind variable within BEGIN END David G. Johnston 18:59
Re: Database views metadata always nullable columns basuraspam - 19:30
Re: YNT: Re: Using bind variable within BEGIN END Adrian Klaver 20:00
YNT: Re: YNT: Re: Using bind variable within BEGIN END gulsumramazanoglu 20:19

June 5, 2017

Thread Author Time
Delete failing with -- permission denied anand086 20:44
Re: Delete failing with -- permission denied Tom Lane 21:15
Re: Delete failing with -- permission denied anand086 21:34
Re: Delete failing with -- permission denied David G. Johnston 21:43
Re: Delete failing with -- permission denied Adrian Klaver 22:14

June 7, 2017

Thread Author Time
Not getting the expected results for a simple where not in Jonathan Moules 12:20
Re: Not getting the expected results for a simple where not in Adrian Klaver 12:49
Re: Not getting the expected results for a simple where not in Adrian Klaver 13:28

June 12, 2017

Thread Author Time
crosstab category mix Majid Khan 07:53
Re: crosstab category mix Steve Midgley 13:46

June 16, 2017

Thread Author Time
Fwd: Re: crosstab category mix 📎 Majid Khan 12:35
Re: crosstab category mix 📎 Samed YILDIRIM 15:03

June 19, 2017

Thread Author Time
Find rows with "timestamp out of range" Saiful Muhajir 07:04
Find rows with "timestamp out of range" Saiful Muhajir 07:11
Re: Find rows with "timestamp out of range" vinny 07:54
Re: Find rows with "timestamp out of range" Saiful Muhajir 07:57
Re: Find rows with "timestamp out of range" 📎 Samed YILDIRIM 08:37
Re: Find rows with "timestamp out of range" Adrian Klaver 13:25
Re: Find rows with "timestamp out of range" Tom Lane 13:33

June 20, 2017

Thread Author Time
Re: Find rows with "timestamp out of range" Saiful Muhajir 01:48

July 6, 2017

Thread Author Time
Finding the negative Ed Rouse 19:13
Re: Finding the negative Vincent Elschot 19:25
Re: Finding the negative Tom Lane 19:43

July 10, 2017

Thread Author Time
Function with table Valued Parameters execution issue Kanjibhai.Kanzaria 12:49
Re: Function with table Valued Parameters execution issue Adrian Klaver 13:26

July 13, 2017

Thread Author Time
Function with table Valued Parameters execution issue Kanjibhai.Kanzaria 13:53

July 18, 2017

Thread Author Time
Steps to place standby database in read write Prashanth Reddy 01:27
Filter JSONB on Foreign Table in postgres_fdw Luan Huynh 03:06
Re: Steps to place standby database in read write Prashanth Reddy 14:58
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write Maddali, Srinivas 15:01
Re: [ADMIN] Steps to place standby database in read write Ashish Tiwari 15:02
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write Prashanth Reddy 15:35
Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database in read write Maddali, Srinivas 15:59

July 21, 2017

Thread Author Time
commit not completing - how to investigate? Tim Dudgeon 11:32
Re: commit not completing - how to investigate? Tom Lane 14:14
Re: commit not completing - how to investigate? Tim Dudgeon 15:18
Re: commit not completing - how to investigate? Tom Lane 17:23
How to duplicate postgres 9.4 database srilinux 19:28
Re: How to duplicate postgres 9.4 database Igor Neyman 20:07

July 22, 2017

Thread Author Time
Re: How to duplicate postgres 9.4 database srilinux 23:43

July 25, 2017

Thread Author Time
Postgresql “alter column type” creates an event which contains “temp_table_xxx” Zehra Gül Çabuk 06:18
Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx” Tom Lane 14:18
Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx” Craig Ringer 15:04
Re: How to duplicate postgres 9.4 database Scott Marlowe 21:07

July 28, 2017

Thread Author Time
Issues with lag command Mohamed DIA 17:48
Re: Issues with lag command Steve Midgley 19:21
Re: Issues with lag command David G. Johnston 19:29
Re: Issues with lag command Igor Neyman 19:53
created database but access is not copied ? any suggestions srilinux 20:43
Re: created database but access is not copied ? any suggestions David G. Johnston 20:57
Re: created database but access is not copied ? any suggestions srilinux 21:16
Re: created database but access is not copied ? any suggestions David G. Johnston 23:00

July 29, 2017

Thread Author Time
Re: Issues with lag command Harald Fuchs 08:05
Re: created database but access is not copied ? any suggestions srilinux 17:38

July 31, 2017

Thread Author Time
Database duplicate copy srilinux 14:57
Odd unfamiliar Postgres SQL syntax Sonny 16:42
Re: Odd unfamiliar Postgres SQL syntax David G. Johnston 19:01
Re: Odd unfamiliar Postgres SQL syntax Pavel Stehule 19:02
Re: Odd unfamiliar Postgres SQL syntax Tom Lane 19:03

Aug. 1, 2017

Thread Author Time
PostgreSQL connection with Android Studio Majid Khan 12:01
Re: PostgreSQL connection with Android Studio Steve Midgley 15:40

Aug. 7, 2017

Thread Author Time
Better way to sort a JSONB array? Michael Moore 20:13
Re: Better way to sort a JSONB array? Steve Midgley 20:51
Re: Better way to sort a JSONB array? Michael Moore 21:12
Re: Better way to sort a JSONB array? Steve Midgley 21:17
Re: Better way to sort a JSONB array? Michael Moore 21:36
Re: Better way to sort a JSONB array? David G. Johnston 21:36
Re: Better way to sort a JSONB array? Michael Moore 21:38
Re: Better way to sort a JSONB array? Michael Moore 21:53
Re: Better way to sort a JSONB array? David G. Johnston 22:04
Re: Better way to sort a JSONB array? Michael Moore 22:10

Aug. 10, 2017

Thread Author Time
Re: Amazon.co.jpからセキュリティコードをお送りします Masaru Sugawara 10:12
Replication and Field Level Encryption Jason Aleski 17:04
Re: Replication and Field Level Encryption Steve Midgley 22:11

Aug. 11, 2017

Thread Author Time
Always getting back a row, even with no results Jonathan Moules 13:57
Re: Always getting back a row, even with no results Achilleas Mantzios 14:28
Re: Always getting back a row, even with no results David G. Johnston 15:18
Re: Always getting back a row, even with no results Jonathan Moules 15:30
Re: Always getting back a row, even with no results Jonathan Moules 15:36
Re: Always getting back a row, even with no results David G. Johnston 15:43

Aug. 12, 2017

Thread Author Time
Updating jsonb rows Michael Moore 01:08
Re: Updating jsonb rows David G. Johnston 01:18
Re: Always getting back a row, even with no results Michael Moore 02:41

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

Browse Archives

Prev | Next