pgsql-sql since 2015-09-16 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

Sept. 16, 2015

Thread Author Time
Re: View not using index gmb 04:45

Sept. 20, 2015

Thread Author Time
Recursive merging of overlapping arrays in a column dave 11:12
Re: Recursive merging of overlapping arrays in a column Rob Sargent 14:00
Re: Recursive merging of overlapping arrays in a column dave 15:57
Re: Recursive merging of overlapping arrays in a column David G. Johnston 17:43
Re: Recursive merging of overlapping arrays in a column dave 19:40

Sept. 21, 2015

Thread Author Time
Re: Recursive merging of overlapping arrays in a column hari.fuchs 09:45
Re: Recursive merging of overlapping arrays in a column dave 12:19

Sept. 22, 2015

Thread Author Time
problem with regexp_matches in nested funcion Isaac Marco Blancas 09:00
problem with regexp_matches in nested funcion David G. Johnston 12:36
Re: problem with regexp_matches in nested funcion Isaac Marco Blancas 15:11

Nov. 6, 2015

Thread Author Time
query option in COPY postgres masyaf 20:22
Re: query option in COPY postgres David G. Johnston 22:02
Re: query option in COPY postgres Adrian Klaver 22:40
Re: query option in COPY postgres masyaf 22:54

Nov. 9, 2015

Thread Author Time
Re: query option in COPY postgres Adrian Klaver 17:13

Nov. 12, 2015

Thread Author Time
Exception Handling in Postgis function ranjitsaurav 07:35

Nov. 15, 2015

Thread Author Time
Re: How would I get rid of trailing blank line? david.paulo 02:17

Nov. 16, 2015

Thread Author Time
Need more info on PL/pgSQL compile listing Michael Moore 23:29

Nov. 17, 2015

Thread Author Time
Re: Need more info on PL/pgSQL compile listing Tom Lane 00:02
Re: Need more info on PL/pgSQL compile listing Michael Moore 00:36

Nov. 19, 2015

Thread Author Time
plpgsql: how to use a composite type varray 卢迪 08:09
Re: plpgsql: how to use a composite type varray Alexander Shereshevsky 09:21
Re: plpgsql: how to use a composite type varray 卢迪 10:23
Re: plpgsql: how to use a composite type varray Alexander Shereshevsky 11:24
Re: plpgsql: how to use a composite type varray 卢迪 11:48
Re: plpgsql: how to use a composite type varray Tom Lane 15:10

Nov. 23, 2015

Thread Author Time
Select values by interval Markus Wolters 16:37
Re: Select values by interval David G. Johnston 16:49
Re: Select values by interval Andreas Kretschmer 17:22
Re: Select values by interval David G. Johnston 17:25
Re: Select values by interval Andreas Kretschmer 17:31
ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:38
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:13
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:23
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:36
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:39

Nov. 24, 2015

Thread Author Time
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 17:27
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Tom Lane 22:02
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Alvaro Herrera 22:10
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:13
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Tom Lane 22:24
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:27
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:42

Nov. 29, 2015

Thread Author Time
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:23

Dec. 2, 2015

Thread Author Time
unique constraint definition within create table Andreas Kretschmer 06:36
Re: unique constraint definition within create table Tom Lane 14:46
Re: unique constraint definition within create table Adrian Klaver 14:59
Re: unique constraint definition within create table David G. Johnston 18:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:41
Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 20:44
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:46
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Adrian Klaver 20:47
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 21:02
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:06
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:15
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Pavel Stehule 21:24
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:44
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:49
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:56
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:02
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:36
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 22:38
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:08
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 23:24
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:34
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 23:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:56

Dec. 3, 2015

Thread Author Time
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 00:14
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 00:34
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 00:39
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 00:51
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 01:21
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 01:46
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 05:03
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 13:00
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 15:33
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 16:33
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 16:48
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 18:29
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 19:26
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:38
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:11
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:55
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:08
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:15
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:19
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:27
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:41
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:54
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:57
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:01

Dec. 8, 2015

Thread Author Time
Re: unique constraint definition within create table Vik Fearing 06:16
来自test的邮件 test 08:39
Re: unique constraint definition within create table Andreas Kretschmer 12:05
call by reference vs call by value Michael Moore 19:07
Re: call by reference vs call by value David G. Johnston 19:15
How to manually load RETURNS SETOF RECORD? Michael Moore 19:34
Re: How to manually load RETURNS SETOF RECORD? Tom Lane 19:49
Re: How to manually load RETURNS SETOF RECORD? Adrian Klaver 20:14
Re: call by reference vs call by value Michael Moore 20:25
Re: call by reference vs call by value Pavel Stehule 20:29
Re: call by reference vs call by value Pavel Stehule 20:31
Re: How to manually load RETURNS SETOF RECORD? Michael Moore 20:42
Re: call by reference vs call by value Michael Moore 20:55

Dec. 9, 2015

Thread Author Time
CVS to In_list without dynamic SQL, how? Michael Moore 20:16
Re: CVS to In_list without dynamic SQL, how? David G. Johnston 20:19
Re: CVS to In_list without dynamic SQL, how? Michael Moore 21:30
regexp_replace question/suggestions needed Christopher Molnar 21:57
Re: CVS to In_list without dynamic SQL, how? Corey Huinker 21:57
Regexp_replace question/assistance needed Christopher Molnar 21:59
Re: CVS to In_list without dynamic SQL, how? Michael Moore 22:28
Re: Regexp_replace question/assistance needed Michael Moore 23:04

Dec. 10, 2015

Thread Author Time
Re: CVS to In_list without dynamic SQL, how? David G. Johnston 00:51
Re: CVS to In_list without dynamic SQL, how? Michael Moore 19:51

Dec. 14, 2015

Thread Author Time
Re: regexp_replace question/suggestions needed Corey Huinker 20:40
Re: regexp_replace question/suggestions needed Hector Vass 21:47

Dec. 15, 2015

Thread Author Time
Name/Value array to table row Michael Moore 01:20
Re: Name/Value array to table row David G. Johnston 01:31
Re: Name/Value array to table row Michael Moore 18:54
Re: Name/Value array to table row Michael Moore 21:01

Dec. 16, 2015

Thread Author Time
cant get what I want from array_to_json (simple) Michael Moore 21:23
Re: cant get what I want from array_to_json (simple) David G. Johnston 21:42
Help with complicated query (total SQL newb!) britt_mcclafferty 22:06

Dec. 17, 2015

Thread Author Time
Re: Help with complicated query (total SQL newb!) Adrian Klaver 00:19
Re: cant get what I want from array_to_json (simple) Michael Moore 18:25

Dec. 18, 2015

Thread Author Time
array of composite type Michael Moore 00:03
Re: array of composite type David G. Johnston 00:13

Dec. 29, 2015

Thread Author Time
Stucks in the middle Yevgeny 11:11
Re: Stucks in the middle Steve Midgley 18:23
Re: Stucks in the middle Adrian Klaver 18:24

Dec. 30, 2015

Thread Author Time
question on row level security Tim Dudgeon 16:58
Re: question on row level security David G. Johnston 17:19
Re: question on row level security Tim Dudgeon 17:28
Re: question on row level security Adrian Klaver 17:28
Re: question on row level security Joe Conway 17:32
Re: question on row level security Karsten Hilbert 17:37
Re: question on row level security Tim Dudgeon 17:37
Re: question on row level security David G. Johnston 17:42

Jan. 5, 2016

Thread Author Time
plv8 installation problem Belju Paul 08:56
Re: plv8 installation problem Adrian Klaver 15:59
Re: [SQL] plv8 installation problem Adrian Klaver 17:09

Jan. 6, 2016

Thread Author Time
Re: [SQL] plv8 installation problem Adrian Klaver 00:34

Jan. 7, 2016

Thread Author Time
public synonym Eugene Yin 20:17
To get the column names, data types, and nullables of tables in the schema owned by MASTER_USER Eugene Yin 20:22
Re: public synonym [email protected] 20:27
Re: To get the column names, data types, and nullables of tables in the schema owned by MASTER_USER Joe Conway 20:46
Re: public synonym Adrian Klaver 22:03

Jan. 8, 2016

Thread Author Time
UPDATE without naming columns Michael Moore 01:09

Jan. 9, 2016

Thread Author Time
Re: Stucks in the middle Yevgeny 21:46
Re: Stucks in the middle bricklen 21:50

Jan. 10, 2016

Thread Author Time
BLOBs Eugene Yin 06:20
Re: BLOBs Tom Lane 07:12

Jan. 11, 2016

Thread Author Time
Re: BLOBs Eugene Yin 00:37
Re: BLOBs Andreas Joseph Krogh 10:09
Re: BLOBs 📎 Eugene Yin 15:37
Re: BLOBs Andreas Joseph Krogh 17:48
Very cool 9.5 feature Michael Moore 18:47

Jan. 12, 2016

Thread Author Time
Re: BLOBs 📎 Eugene Yin 01:32
Re: BLOBs Andreas Joseph Krogh 07:09

Jan. 13, 2016

Thread Author Time
BYTEA vs BLOB Eugene Yin 01:45
best way sync data from Oracle to PostgreSQL? Michael Moore 16:37
Re: best way sync data from Oracle to PostgreSQL? Adrian Klaver 17:48

Jan. 14, 2016

Thread Author Time
Re: BYTEA vs BLOB John DeSoi 16:00

Jan. 15, 2016

Thread Author Time
remove null values from json Michael Moore 20:24
strip values from json doc Michael Moore 21:43

Jan. 16, 2016

Thread Author Time
Re: BYTEA vs BLOB Eugene Yin 16:08

Jan. 17, 2016

Thread Author Time
Re: BYTEA vs BLOB Andreas Joseph Krogh 15:01
tablespace Eugene Yin 16:28
Re: BYTEA vs BLOB 📎 Eugene Yin 16:56
Re: BYTEA vs BLOB Andreas Joseph Krogh 17:01
Re: BYTEA vs BLOB 📎 Eugene Yin 17:37
Re: BYTEA vs BLOB Andreas Joseph Krogh 17:42
Re: BLOBs 📎 Eugene Yin 19:26
BYTEA Eugene Yin 19:33
Re: BYTEA Adrian Klaver 20:29
Re: BLOBs Andreas Joseph Krogh 22:08
Re: BYTEA Andreas Joseph Krogh 22:09
Re: BYTEA Thomas Kellerer 22:13
Re: BLOBs Thomas Kellerer 22:17

Jan. 18, 2016

Thread Author Time
Re: BYTEA Cat 00:25
Re: BYTEA Karsten Hilbert 10:05
Re: BYTEA Andreas Joseph Krogh 13:06
Re: BLOBs Andreas Joseph Krogh 13:08
Re: BYTEA 📎 Eugene Yin 15:40
Re: BYTEA Andreas Joseph Krogh 15:50
Re: BYTEA 📎 Eugene Yin 16:30
Re: BYTEA Andreas Joseph Krogh 17:26

Jan. 19, 2016

Thread Author Time
Re: remove null values from json Pavel Stehule 18:09
filtering columns in function David Ford 19:59
Re: filtering columns in function David G. Johnston 20:21

Jan. 28, 2016

Thread Author Time
PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 06:31
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Adrian Klaver 16:27
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 16:33
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Adrian Klaver 16:42
Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! Venkatesan, Sekhar 16:53
insert a text file into a variable in order to insert into a bytea column Arthur Lewis 18:10
Re: insert a text file into a variable in order to insert into a bytea column Adrian Klaver 18:20
Re: insert a text file into a variable in order to insert into a bytea column Arthur Lewis 18:46

Browse Archives

Prev | Next