pgsql-sql since 2017-07-22 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

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

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

Browse Archives

Prev | Next