pgsql-sql since 2014-01-24 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

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

April 4, 2014

Thread Author Time
Formatting query result like a calendar dahd101+hm3ufk 12:34
Re: Formatting query result like a calendar Jan Ostrochovsky 14:43

April 8, 2014

Thread Author Time
performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 11:53
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 13:50
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 17:33
Re: Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 17:41

May 1, 2014

Thread Author Time
Optimize query for listing un-read messages Andreas Joseph Krogh 12:51

May 4, 2014

Thread Author Time
Re: Optimize query for listing un-read messages Brice André 12:06
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 16:40
Re: Optimize query for listing un-read messages Brice André 16:49
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 16:53
Re: Optimize query for listing un-read messages Brice André 17:43
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 18:03

May 9, 2014

Thread Author Time
group number Rene Romero Benavides 20:15
Re: group number Pavel Stehule 20:22

May 18, 2014

Thread Author Time
matching column of regexps James Cloos 23:44

May 19, 2014

Thread Author Time
Re: matching column of regexps Vik Fearing 00:35
Re: matching column of regexps James Cloos 05:43
How to clean up phone-numbers with regex? Andreas 08:54
Re: How to clean up phone-numbers with regex? Rob Sargent 13:39
Re: How to clean up phone-numbers with regex? Steve Crawford 15:43
Re: How to clean up phone-numbers with regex? Steve Crawford 15:44
Re: How to clean up phone-numbers with regex? Rob Sargent 15:49
Re: How to clean up phone-numbers with regex? David G Johnston 15:52

May 27, 2014

Thread Author Time
Question about Array data type in PostgreSQL and their link with hash table concept Dariyoosh Dariyoosh 12:39
Re: Question about Array data type in PostgreSQL and their link with hash table concept Luca Vernini 12:44
Re: Question about Array data type in PostgreSQL and their link with hash table concept Dariyoosh Dariyoosh 12:50
Set flag column on update if other columns change? Steve Wampler 16:00
Re: Set flag column on update if other columns change? Andreas Kretschmer 16:21
Re: Set flag column on update if other columns change? Steve Wampler 16:23

May 28, 2014

Thread Author Time
Re: Unquoted column names fold to lower case creechy 05:47
Three way foreign keys Gary Stainburn 11:24

May 29, 2014

Thread Author Time
PGsql function timestamp issue ng 20:46
Re: PGsql function timestamp issue Jonathan S. Katz 20:52
Re: PGsql function timestamp issue Steve Crawford 21:13
Re: PGsql function timestamp issue bricklen 22:00

June 9, 2014

Thread Author Time
Re: Parameterized Query David G Johnston 13:36
Problem with strange chars in text filed. Bruce 16:02
Re: Problem with strange chars in text filed. Rob Sargent 16:07
Fwd: Problem with strange chars in text filed. Bruce 17:59
Re: Problem with strange chars in text filed. Adrian Klaver 23:06

June 10, 2014

Thread Author Time
Re: Problem with strange chars in text filed. Bruce 01:44

June 11, 2014

Thread Author Time
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:38
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:42
Re: need to pass the csv file name as value to the column file_id David G Johnston 14:35
Re: need to pass the csv file name as value to the column file_id David G Johnston 16:03

June 12, 2014

Thread Author Time
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:17
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:31
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 14:02
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 19:32
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:49
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:52
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:04
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:07
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 20:36
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 21:28

June 13, 2014

Thread Author Time
cannot install 9.4 on trusty because of the libpq5 version rawi 14:01
Re: cannot install 9.4 on trusty because of the libpq5 version Adrian Klaver 14:31
Re: cannot install 9.4 on trusty because of the libpq5 version rawi 14:49

July 23, 2014

Thread Author Time
Is CREATE TABLE non-blocking ? Benjamin Dugast 10:33
Re: Is CREATE TABLE non-blocking ? hubert depesz lubaczewski 13:43
Re: Is CREATE TABLE non-blocking ? David G Johnston 14:18
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 15:13
Re: Is CREATE TABLE non-blocking ? Rob Sargent 15:52

July 24, 2014

Thread Author Time
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 08:36

July 25, 2014

Thread Author Time
Re: PGsql function timestamp issue Vinayak Pokale 08:59

July 29, 2014

Thread Author Time
Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:52
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 09:56
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:59
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:01
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:05
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:12
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:21
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:27

Browse Archives

Prev | Next