pgsql-sql since 2004-02-18 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

Feb. 18, 2004

Thread Author Time
Re: CHAR(n) always trims trailing spaces in 7.4 scott.marlowe 00:07
Re: CHAR(n) always trims trailing spaces in 7.4 terry 00:23
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 00:25
Re: CHAR(n) always trims trailing spaces in 7.4 elein 00:27
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 03:53
Indexes and statistics David Witham 04:43
Re: Indexes and statistics Tom Lane 05:10
Disabling constraints Kumar 05:13
Re: bytea or blobs? sad 06:14
Re: Indexes and statistics David Witham 06:23
Re: bytea or blobs? Dana Hudes 06:44
Re: bytea or blobs? Achilleus Mantzios 07:18
Re: Return relation table data in a single value CSV Richard Huxton 09:29
Re: CHAR(n) always trims trailing spaces in 7.4 Richard Huxton 09:40
Re: bytea or blobs? Richard Huxton 09:44
Re: bytea or blobs? Dana Hudes 15:17
Re: Indexes and statistics Tom Lane 15:21
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 15:56
Re: [SQL] 7.4 - FK constraint performance Stephan Szabo 16:03
Re: bytea or blobs? Richard Huxton 16:08
Re: [SQL] 7.4 - FK constraint performance Tom Lane 17:27
Re: CHAR(n) always trims trailing spaces in 7.4 Jeremy Smith 18:06
Inserting NULL into Integer column Jeremy Smith 19:25
Re: Inserting NULL into Integer column scott.marlowe 19:43
Re: CHAR(n) always trims trailing spaces in 7.4 elein 20:05
Re: Inserting NULL into Integer column Jeremy Smith 20:15
Re: Inserting NULL into Integer column scott.marlowe 20:19
Re: Inserting NULL into Integer column Jeremy Smith 20:43
Re: Inserting NULL into Integer column scott.marlowe 20:44
Re: Inserting NULL into Integer column Rod Taylor 20:53
Re: Inserting NULL into Integer column scott.marlowe 20:58
SQL / Join Help FastEddie 21:15
Re: Inserting NULL into Integer column Rod Taylor 21:29
Re: Inserting NULL into Integer column scott.marlowe 21:50

Feb. 19, 2004

Thread Author Time
Need some help with crafting a query to do major update Sean Shanny 00:51
Re: Need some help with crafting a query to do major update Stephan Szabo 03:11
Re: Indexes and statistics Iain 03:44
Distributed Transactions George A.J 03:46
Re: Distributed Transactions Josh Berkus 04:39
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 04:58
Compiling pl/pgsql functions Rodrigo Sakai 12:44
Re: Compiling pl/pgsql functions Viorel Dragomir 14:01
Re: Function Sumita Biswas 15:10
crosstabs Philippe Lang 16:02
Re: Compiling pl/pgsql functions Stephan Szabo 16:20
postgresql multiple insert slow Michael L. Hostbaek 16:32
Re: Distributed Transactions scott.marlowe 16:38
Re: Compiling pl/pgsql functions Rod Taylor 16:48
Re: Compiling pl/pgsql functions Rodrigo Sakai 17:05
Re: [SQL] crosstabs daq 17:23
Re: crosstabs Richard Huxton 17:26
Re: crosstabs Philippe Lang 17:28
DISTINCT ON troubles Jeremy Smith 18:10
Re: CHAR(n) always trims trailing spaces in 7.4 elein 18:55
Re: crosstabs Joe Conway 18:58
Re: Compiling pl/pgsql functions Joe Conway 19:00
Re: Compiling pl/pgsql functions Josh Berkus 19:26
Re: DISTINCT ON troubles Josh Berkus 19:28
Re: DISTINCT ON troubles Jeremy Smith 19:34
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 20:06
Re: Compiling pl/pgsql functions Jan Wieck 20:09
Re: Compiling pl/pgsql functions Richard Huxton 20:49
Re: Date / interval question Gnugeek 21:04
Re: DISTINCT ON troubles Brian Knox 21:06
Re: DISTINCT ON troubles scott.marlowe 21:39
Re: DISTINCT ON troubles scott.marlowe 21:51
Re: Distributed Transactions Tom Lane 22:38
Help refining/eliminating recursive selects Edmund Bacon 23:09
Re: Help refining/eliminating recursive selects Stephan Szabo 23:52

Feb. 20, 2004

Thread Author Time
Re: Help refining/eliminating recursive selects Yudie 00:16
Row counts/data changes. Any catalog table that has this info? David B 02:35
pg_restore - don´t restore. Why? 2000info 03:24
Re: Function Sumita Biswas 06:39
Re: [SQL] Row counts/data changes. Any catalog table that has this info? daq 07:44
Re: Function Sumita Biswas 08:43
transaction block causing trouble Fabian 09:56
Problem with FOR SELECT in plpgsql function Plant Thomas 10:07
Re: Problem with FOR SELECT in plpgsql function Richard Huxton 11:09
Re: pg_restore - don?t restore. Why? Andrew Sullivan 12:14
Re: bytea or blobs? Igor Shevchenko 12:42
create function atof? Mark Tabash 14:01
create function atof? mark 14:04
Re: create function atof? Achilleus Mantzios 14:24
Re: create function atof? Tom Lane 14:54
date format in 7.4 Silke Trissl 14:58
Binary retrieval - *Best practice* recommendations... beyaNet Consultancy 15:22
Re: date format in 7.4 scott.marlowe 15:27
Re: date format in 7.4 Tom Lane 15:32
Creating constraint sometime fail in a transaction Olivier Hubaut 15:49
Re: date format in 7.4 Richard Huxton 15:57
Re: Creating constraint sometime fail in a transaction Tom Lane 16:37
Re: Row counts/data changes. Any catalog table that has this info? Josh Berkus 18:53
Re: Date Foo. Brian Knox 20:25
Re: Date Foo. scott.marlowe 21:18

Feb. 21, 2004

Thread Author Time
User defined types -- Social Security number... Greg Patnude 02:31
Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems] 08:12
Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems] 08:12
Re: postgresql multiple insert slow Christopher Browne 15:03
Re: postgresql multiple insert slow Tom Lane 16:03
Re: Function Tom Lane 16:10

Feb. 22, 2004

Thread Author Time
Re: searching polygons elein 02:12
Re: [SQL] crosstabs joseph speigle 18:54
Re: User defined types -- Social Security number... Josh Berkus 19:32
Re: Compiling pl/pgsql functions Josh Berkus 19:34

Feb. 23, 2004

Thread Author Time
Re: User defined types -- Social Security number... Greg Patnude 00:45
Re: Postgres DB Sumita Biswas 02:54
Re: Postgres DB Tom Lane 03:29
Re: Error Number in Function Sumita Biswas 03:33
Re: User defined types -- Social Security number... Christopher Browne 04:07
Input Arguments Sumita Biswas 06:21
DATEADD Sumita Biswas 08:17
EXECUTing QUERY: Sumita Biswas 08:33
unicode(utf-8) problem ! john 08:44
Re: Postgres DB Sumita Biswas 08:54
plpgsql function returning SETOF RECORD Question jbduffy 13:21

Feb. 24, 2004

Thread Author Time
BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() PostgreSQL Bugs List 01:26
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Bruno Wolff III 02:11
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Tom Lane 05:37
Re: BUG #1083: Insert query reordering interacts badly with Martin Langhoff (Catalyst IT) 06:46
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Tom Lane 06:51
Enterprice support in PostgreSQL George A.J 10:02
Re: BUG #1083: Insert query reordering interacts badly with Martin Langhoff 10:47
CURSORS - Please help urgent. Sumita Biswas (sbiswas) 11:51
Execute Query in Postgres Function Sumita Biswas (sbiswas) 15:35
Materialized View Summary Jonathan M. Gardner 16:11
Re: [SQL] Materialized View Summary Richard Huxton 17:11
Re: [HACKERS] [SQL] Materialized View Summary Hans-Jürgen Schönig 17:40
tsearch2 trigger alternative Chris Gamache 18:58
Re: [HACKERS] [SQL] Materialized View Summary Robert Treat 21:48
Re: [HACKERS] [SQL] Materialized View Summary Jonathan Gardner 22:19

Feb. 25, 2004

Thread Author Time
PLSQL Question regarding multiple inserts Humble Geek 03:56
Re: [HACKERS] [SQL] Materialized View Summary Jonathan M. Gardner 08:19
Re: [HACKERS] Materialized View Summary Mark Gibson 11:35
Last day of month Kumar 12:35
Re: [HACKERS] [SQL] Materialized View Summary Robert Treat 15:46
Scalar in a range (but textual not numeric) Richard Huxton 19:18
Re: Scalar in a range (but textual not numeric) Richard Huxton 20:36
Re: Scalar in a range (but textual not numeric) Joe Conway 20:56
Re: Scalar in a range (but textual not numeric) Tom Lane 21:32
Re: Scalar in a range (but textual not numeric) Richard Huxton 22:08
Re: Scalar in a range (but textual not numeric) Richard Huxton 22:10
Re: Scalar in a range (but textual not numeric) Tom Lane 22:32
Re: Scalar in a range (but textual not numeric) Tom Lane 22:37

Feb. 26, 2004

Thread Author Time
updating remote database Kenneth Gonsalves 02:54
Re: Last day of month Greg Sabino Mullane 03:07
Re: Last day of month Joe Conway 04:27
Re: Last day of month Joe Conway 04:30
Unicode Support Sumita Biswas (sbiswas) 05:51
Re: Scalar in a range (but textual not numeric) Richard Huxton 08:03
Re: updating remote database Richard Huxton 08:15
Re: updating remote database Olivier Hubaut 09:51
Field list from table Jan Pips 09:51
Re: updating remote database Achilleus Mantzios 09:55
Triggers Philip J. Boonzaaier 10:18
Re: Field list from table Christopher Browne 13:08
Return more than a record Kumar 13:51
Re: Last day of month Frank Bax 14:45
Re: Scalar in a range (but textual not numeric) Edmund Bacon 14:55
Re: Scalar in a range (but textual not numeric) Bruno Wolff III 15:26
Re: Return more than a record Stephan Szabo 15:29
a few Questions about quoted varaibles in psql Leo Leo 15:58
Re: Last day of month Michael Chaney 16:37

Feb. 27, 2004

Thread Author Time
Re: Return more than a record Kumar 04:51
Re: Return more than a record Stephan Szabo 05:16
Re: BUG #1083: Insert query reordering interacts badly with Bruno Wolff III 13:46
Convert INT to INTERVAL? Brian Knox 16:54
Re: Convert INT to INTERVAL? Stephan Szabo 17:28
Re: searching polygons David 17:29
Re: Convert INT to INTERVAL? Bruno Wolff III 17:40
Re: Convert INT to INTERVAL? Michael Chaney 18:07
Re: Convert INT to INTERVAL? Tom Lane 18:12
VIEW on lookup table JJ Gabor 22:18

Feb. 28, 2004

Thread Author Time
Re: User defined types -- Social Security number... Bruce Momjian 16:18

Feb. 29, 2004

Thread Author Time
Re: Enterprice support in PostgreSQL Bruce Momjian 02:44
returning a recordset from PLpg/SQL Terence Kearns 12:36
Re: returning a recordset from PLpg/SQL Tom Lane 15:11
Trouble with composite types Yasir Malik 20:22
Re: Field list from table rixder 20:48
Re: plpgsql function returning SETOF RECORD Question Joe Conway 23:32
Re: Trouble with composite types Joe Conway 23:35

March 1, 2004

Thread Author Time
How to get Rows Count Abdul Wahab Dahalan 02:06
Re: User defined types -- Social Security number... Michael Chaney 03:17
Re: Postgres DB Michael Chaney 03:20
Re: How to get Rows Count Iain 03:58
Re: User defined types -- Social Security number... Christopher Browne 04:11
Re: PLSQL Question regarding multiple inserts V i s h a l Kashyap @ [Sai Hertz And Control Systems] 04:17
Re: Field list from table Denis 05:30
Re: returning a recordset from PLpg/SQL 📎 Terence Kearns 15:19
Re: returning a recordset from PLpg/SQL Stephan Szabo 15:31
Re: User defined types -- Social Security number... Dana Hudes 16:54
Re: returning a recordset from PLpg/SQL Tom Lane 17:10
Re: User defined types -- Social Security number... Steve Crawford 17:42
Re: returning a recordset from PLpg/SQL Joe Conway 18:45
Re: User defined types -- Social Security number... Michael Chaney 21:12
SYSDATE in PostgreSQL !? Louie Kwan 21:18
Re: User defined types -- Social Security number... Michael Chaney 21:18
select by groups Martin Marques 22:20
Re: select by groups Manuel Sugawara 22:32
Re: SYSDATE in PostgreSQL !? Oliver Elphick 22:57
Re: returning a recordset from PLpg/SQL Terence Kearns 23:57

Browse Archives

Prev | Next