pgsql-sql before 2014-04-04 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

Nov. 9, 2013

Thread Author Time
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
Re: Function Issue ALMA TAHIR 13:13
Re: how to effectively SELECT new "customers" David Johnston 15:39
Re: how to effectively SELECT new "customers" Jan Ostrochovsky 16:12
Re: how to effectively SELECT new "customers" David Johnston 16:33

March 1, 2014

Thread Author Time
Re: how to effectively SELECT new "customers" Jan Ostrochovsky 14:24
Re: how to effectively SELECT new "customers" Jan Ostrochovsky 16:09

March 2, 2014

Thread Author Time
Re: how to effectively SELECT new "customers" David Johnston 04:08

March 3, 2014

Thread Author Time
Re: Function Issue ALMA TAHIR 11:32
creating a new aggregate function Seb 17:16
Re: creating a new aggregate function David Johnston 17:35
Re: creating a new aggregate function Seb 20:44
Re: creating a new aggregate function David Johnston 21:12

March 4, 2014

Thread Author Time
Re: creating a new aggregate function Seb 00:07
Re: creating a new aggregate function Tom Lane 00:17
Re: creating a new aggregate function Sebastian P. Luque 00:57
Re: pgsql-sq-owner ALMA TAHIR 05:35
pgsql-sql-owner ALMA TAHIR 05:38
Re: pgsql-sq-owner Adrian Klaver 15:08
Re: Function Issue Adrian Klaver 15:14

March 9, 2014

Thread Author Time
Foreign key to a partial key Simon G 01:19
Re: Foreign key to a partial key David Johnston 02:37
Re: Foreign key to a partial key Simon G 16:19
Re: Foreign key to a partial key David Johnston 16:35
Re: Foreign key to a partial key Simon G 17:28

March 18, 2014

Thread Author Time
problem with update order (?) ssylla 12:22
Alter column with views depended on it without drop views Emi Lu 17:41

March 19, 2014

Thread Author Time
Table results format - should I use crosstab? If so, how? Jennifer Mackown 14:58
Re: Table results format - should I use crosstab? If so, how? David Johnston 15:47
Re: Table results format - should I use crosstab? If so, how? hari.fuchs 17:56
Can I use a constraint to make sure all array elements are positive? AlexK 21:59
Re: Can I use a constraint to make sure all array elements are positive? Vik Fearing 22:08
Re: Can I use a constraint to make sure all array elements are positive? Sergey Konoplev 22:20
Re: Can I use a constraint to make sure all array elements are positive? Vik Fearing 22:35

March 20, 2014

Thread Author Time
SQL Query for Foreign constraint Bhim Kumar 08:01
Re: SQL Query for Foreign constraint Igor Neyman 13:48

Browse Archives

Prev | Next