pgsql-sql since 2013-10-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

Oct. 17, 2013

Thread Author Time
Advice - indexing on varchar fields where only last x characters known Gary Stainburn 11:20
Re: Advice - indexing on varchar fields where only last x characters known Jayadevan M 11:35
Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:45
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:27
Re: Advice - indexing on varchar fields where only last x characters known Alvaro Herrera 18:39
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:43
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 19:16

Oct. 18, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 07:22
Re: Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:37
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 13:44

Oct. 21, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 09:52

Oct. 24, 2013

Thread Author Time
Number of days in a tstzrange? Craig R. Skinner 20:46
Re: Number of days in a tstzrange? Jonathan S. Katz 21:00

Oct. 25, 2013

Thread Author Time
index on values stored in a json array Raphael Bauduin 09:17
Re: index on values stored in a json array Jonathan S. Katz 14:21

Oct. 28, 2013

Thread Author Time
Re: index on values stored in a json array Raphael Bauduin 07:30

Oct. 29, 2013

Thread Author Time
sum of until (running balance) and sum of over date range in the same query M. D. 03:42
Re: sum of until (running balance) and sum of over date range in the same query David Johnston 04:17
Re: Number of days in a tstzrange? Craig R. Skinner 11:34
Re: Re: sum of until (running balance) and sum of over date range in the same query M. D. 13:19

Oct. 30, 2013

Thread Author Time
Re: Number of days in a tstzrange? Craig R. Skinner 10:40
Re: Number of days in a tstzrange? Gavin Flower 18:21

Nov. 4, 2013

Thread Author Time
json and aggregate Diway 20:22
Re: json and aggregate David Johnston 20:38
Re: json and aggregate Diway 21:05
Re: json and aggregate David Johnston 21:15

Nov. 8, 2013

Thread Author Time
Query specific table using relative position in search path George Woodring 16:51
How to script inserts where id is needed as fk Michael Schmidt 19:44
Re: How to script inserts where id is needed as fk Jonathan S. Katz 19:48
Re: Query specific table using relative position in search path Sergey Konoplev 20:42
Re: Query specific table using relative position in search path George Woodring 20:57
Re: Query specific table using relative position in search path Sergey Konoplev 21:32

Nov. 9, 2013

Thread Author Time
Find datatype of a column during the backend flow Ishaya Bhatt 15:27
Re: How to script inserts where id is needed as fk Michael Schmidt 20:09
Re: How to script inserts where id is needed as fk Jonathan S. Katz 21:15
Re: How to script inserts where id is needed as fk David Johnston 21:55
Re: How to script inserts where id is needed as fk Michael Schmidt 23:20

Nov. 10, 2013

Thread Author Time
Re: Find datatype of a column during the backend flow Sergey Konoplev 23:40

Nov. 12, 2013

Thread Author Time
Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:17
Re: Function args: TEXT -vs- VARCHAR? Luca Vernini 18:23

Nov. 13, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 03:07
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:03
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:05
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:17
Re: Function args: TEXT -vs- VARCHAR? Pavel Stehule 14:20
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:25
Re: Function args: TEXT -vs- VARCHAR? Adrian Klaver 14:34
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 15:51
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 16:36
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:14
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 17:51
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:59
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:04
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 18:31

Nov. 14, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 07:41

Nov. 24, 2013

Thread Author Time
Importing MySql dumped db into pgadmin miks87 15:49
Re: Importing MySql dumped db into pgadmin Theodore Petrosky 16:02
Re: Importing MySql dumped db into pgadmin Adrian Klaver 16:08
Re: Importing MySql dumped db into pgadmin miks87 16:11
Re: Importing MySql dumped db into pgadmin miks87 16:21
Re: Importing MySql dumped db into pgadmin Jan Lentfer 16:37
Re: Importing MySql dumped db into pgadmin Adrian Klaver 17:06

Nov. 25, 2013

Thread Author Time
tab delimiter in output Marcin Krawczyk 11:14
Re: tab delimiter in output Ian Lawrence Barwick 11:26
Re: tab delimiter in output Thomas Kellerer 11:42
Re: tab delimiter in output Marcin Krawczyk 12:00
Re: tab delimiter in output Marcin Krawczyk 12:01

Nov. 27, 2013

Thread Author Time
isnumeric(varchar) by psql Emi Lu 21:46
Re: isnumeric(varchar) by psql Venky Kandaswamy 21:54

Dec. 2, 2013

Thread Author Time
Re: tab delimiter in output seikath 09:49

Dec. 5, 2013

Thread Author Time
Re: Results list String to comma separated int David Johnston 03:02
Re: XMLELEMENT produce a lower case of element name David Johnston 03:19

Dec. 11, 2013

Thread Author Time
Scheduled Events Dev Kumkar 11:38
Re: Scheduled Events Dev Kumkar 15:00

Dec. 12, 2013

Thread Author Time
NULLs and composite types Dean Gibson (DB Administrator) 00:19
Re: [GENERAL] Scheduled Events Vick Khera 16:29
Re: NULLs and composite types David Johnston 19:25
Re: NULLs and composite types Dean Gibson (DB Administrator) 21:57
Re: NULLs and composite types Tom Lane 23:57

Dec. 13, 2013

Thread Author Time
Re: NULLs and composite types Dean Gibson (DB Administrator) 04:31

Dec. 16, 2013

Thread Author Time
Query caching (with 8.3) Achilleas Mantzios 10:58
Re: Query caching (with 8.3) Vik Fearing 23:21

Dec. 17, 2013

Thread Author Time
Re: Query caching (with 8.3) Achilleas Mantzios 08:09
Re: Query caching (with 8.3) Vik Fearing 10:32
Re: [ADMIN] Scheduled Events Marcin Krawczyk 12:06
Re: Query caching (with 8.3) Achilleas Mantzios 14:54
Re: Query caching (with 8.3) Gavin Flower 18:37
Re: Query caching (with 8.3) Sergey Konoplev 20:26

Dec. 18, 2013

Thread Author Time
Re: Query caching (with 8.3) Achilleas Mantzios 08:45

Jan. 2, 2014

Thread Author Time
Index on multiple columns VS multiple index Brice André 19:17
Re: Index on multiple columns VS multiple index Jonathan S. Katz 19:22
Re: Index on multiple columns VS multiple index Jonathan S. Katz 19:33
Re: Index on multiple columns VS multiple index Erik Darling 19:41
Re: Index on multiple columns VS multiple index Brice André 19:45
Re: Index on multiple columns VS multiple index Brice André 20:00
Re: Index on multiple columns VS multiple index Jonathan S. Katz 20:05
Re: Index on multiple columns VS multiple index Jonathan S. Katz 20:06
Re: Index on multiple columns VS multiple index Brice André 20:12

Jan. 14, 2014

Thread Author Time
An archiving query - is it safe? Herouth Maoz 11:06
Re: An archiving query - is it safe? Vik Fearing 12:55
Re: An archiving query - is it safe? Herouth Maoz 14:34

Jan. 15, 2014

Thread Author Time
debugging triggers - get original statement? gmb 08:52
Re: debugging triggers - get original statement? Luca Vernini 11:22
Re: debugging triggers - get original statement? gmb 11:30
Re: debugging triggers - get original statement? bricklen 15:25

Jan. 16, 2014

Thread Author Time
about running plpgsqlo.sql minsheng.bai 08:02
Re: about running plpgsqlo.sql Adrian Klaver 15:18

Jan. 22, 2014

Thread Author Time
Deferrable conditional unique constraints Andreas Joseph Krogh 01:34
Re: Deferrable conditional unique constraints Marc Mamin 17:33

Jan. 24, 2014

Thread Author Time
consulting the question about the usage about SSH Tunnel function minsheng.bai 02:06
find all views depend on a schema/table Emi Lu 15:55
Re: find all views depend on a schema/table Tom Lane 16:23
Re: consulting the question about the usage about SSH Tunnel function Adrian Klaver 16:29
Re: consulting the question about the usage about SSH Tunnel function Adrian Klaver 16:48
Re: find all views depend on a schema/table Emi Lu 17:04

Jan. 27, 2014

Thread Author Time
Detecting when field value changes in Foreign Table? bobspero 00:17
How to detect values changed in field of foreign table? Bob Spero 00:20
Re: find all views depend on a schema/table Tim Landscheidt 04:42
Trigger function - variable for schema name ssylla 08:39
Re: Trigger function - variable for schema name Glyn Astill 10:47
Re: Trigger function - variable for schema name Glyn Astill 11:00
Update ordered Andreas Joseph Krogh 14:36
Re: Update ordered Adrian Klaver 14:56
Re: Update ordered Andreas Joseph Krogh 15:01
How to insert rows distributed evenly between referenced rows? Herouth Maoz 15:10
Re: How to insert rows distributed evenly between referenced rows? Erik Darling 15:13
Re: Update ordered Adrian Klaver 15:23
Re: Update ordered Andreas Joseph Krogh 15:37
Re: How to insert rows distributed evenly between referenced rows? Herouth Maoz 15:42
Re: Update ordered Adrian Klaver 15:48
Re: Update ordered Achilleas Mantzios 15:49

Jan. 28, 2014

Thread Author Time
Re: Trigger function - variable for schema name [SOLVED] ssylla 06:26
Re: How to insert rows distributed evenly between referenced rows? Herouth Maoz 11:30

Jan. 30, 2014

Thread Author Time
"Timestamp out of range" Sandeep Devan 13:41
Re: "Timestamp out of range" Adrian Klaver 15:25
Re: How to detect values changed in field of foreign table? Adrian Klaver 15:41

Jan. 31, 2014

Thread Author Time
List all Indexes of a schema or database in CREATE syntax basti 15:18
Re: List all Indexes of a schema or database in CREATE syntax Julien Cigar 16:00

Feb. 3, 2014

Thread Author Time
IDENTIFY_SYSTEM Cezariusz Marek 08:35

Feb. 5, 2014

Thread Author Time
Re: IDENTIFY_SYSTEM Glyn Astill 11:34
Re: IDENTIFY_SYSTEM Cezariusz Marek 12:01
Re: IDENTIFY_SYSTEM Glyn Astill 14:45
Re: IDENTIFY_SYSTEM Glyn Astill 14:51
Re: IDENTIFY_SYSTEM bricklen 16:15

Feb. 11, 2014

Thread Author Time
Time AT TIME ZONE: false result using offset instead of time zone name rawi 07:54
Re: Time AT TIME ZONE: false result using offset instead of time zone name Adrian Klaver 14:32

Feb. 12, 2014

Thread Author Time
Re: Time AT TIME ZONE: false result using offset instead of time zone name rawi 08:24
Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name Adrian Klaver 15:03
Re: Time AT TIME ZONE: false result using offset instead of time zone name rawi 15:29
Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name Adrian Klaver 16:30
Re: Re: Time AT TIME ZONE: false result using offset instead of time zone name Adrian Klaver 17:16

Feb. 14, 2014

Thread Author Time
Re: [SQL] Comparison semantics of CHAR data type 📎 Bruce Momjian 02:47
Re: [SQL] Comparison semantics of CHAR data type 📎 Bruce Momjian 22:02

Feb. 15, 2014

Thread Author Time
Re: Trigger function - variable for schema name [SOLVED] ssylla 10:03
[No subject] avpro avpro 11:18
Re: Gerald Cheves 12:17
Re: Adrian Klaver 15:30
dynamically referencing a column name in a function James Sharrett 21:34
Re: dynamically referencing a column name in a function Adrian Klaver 22:14
Re: dynamically referencing a column name in a function James Sharrett 22:41
Re: dynamically referencing a column name in a function Adrian Klaver 23:29

Feb. 17, 2014

Thread Author Time
Trigger SQL script execution after DROP EXTENSION amul sul 05:52
Re: Trigger SQL script execution after DROP EXTENSION Adrian Klaver 14:26
include ids in query grouped by multipe values karsten 19:49
Re: include ids in query grouped by multipe values Carlos Chapi 21:49
Re: include ids in query grouped by multipe values David Johnston 22:12

Feb. 19, 2014

Thread Author Time
How to unnest an array with element indexes AlexK 19:25
Re: How to unnest an array with element indexes David Johnston 19:32
Re: How to unnest an array with element indexes AlexK 19:57
Re: How to unnest an array with element indexes Pavel Stehule 20:08
Re: How to unnest an array with element indexes Tom Lane 20:16
Re: How to unnest an array with element indexes AlexK 20:55
Re: How to unnest an array with element indexes AlexK 21:53
Selecting consecutive dates as integers in yyyymmdd format AlexK 22:18
Re: Selecting consecutive dates as integers in yyyymmdd format bricklen 23:25

Feb. 20, 2014

Thread Author Time
Re: How to unnest an array with element indexes Pavel Stehule 04:17

Feb. 24, 2014

Thread Author Time
Postgres behavior - Conditional statements Kumar Babu P G 06:37
SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type 📎 amul sul 06:47
array in function Pena Kupen 08:42
Re: array in function Pavel Stehule 08:55
Re: array in function Pena Kupen 09:09
Re: array in function Pavel Stehule 09:31
Re: array in function Pena Kupen 10:05
Re: Postgres behavior - Conditional statements Tom Lane 16:02
Re: Postgres behavior - Conditional statements David Johnston 16:47
Re: [SQL] Comparison semantics of CHAR data type Bruce Momjian 17:09
Re: Postgres behavior - Conditional statements Tom Lane 17:18
Can I specify a copying type for an array element AlexK 17:55
Re: Postgres behavior - Conditional statements David Johnston 18:27
Is there an upper limit on the size of an array if it is indexed? AlexK 20:30
Re: Is there an upper limit on the size of an array if it is indexed? Rob Sargent 20:35
Re: Is there an upper limit on the size of an array if it is indexed? Tom Lane 20:39
Re: Is there an upper limit on the size of an array if it is indexed? AlexK 20:43

Feb. 25, 2014

Thread Author Time
Re: SRF_RETURN_NEXT Error: rows returned by function are not all of the same row type amul sul 04:59

Feb. 27, 2014

Thread Author Time
Function Issue ALMA TAHIR 12:23
how to effectively SELECT new "customers" Jan Ostrochovsky 14:20
Re: Function Issue Tom Lane 14:32
Re: how to effectively SELECT new "customers" David Johnston 15:09

Feb. 28, 2014

Thread Author Time
Re: how to effectively SELECT new "customers" Jan Ostrochovsky 11:44
Re: how to effectively SELECT new "customers" Jan Ostrochovsky 11:45

Browse Archives

Prev | Next