pgsql-sql since 2002-01-27 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Jan. 27, 2002

Thread Author Time
interval and timestamp change? postgresql 00:03
update syntax chester c young 00:18
Re: update syntax Bruce Momjian 00:37
Re: interval and timestamp change? Chris Ruprecht 00:46
Re: interval and timestamp change? Brent Verner 01:03
Re: update syntax chester c young 02:59
Re: update syntax Bruce Momjian 03:40
Re: LIMIT Optimization Tom Lane 03:59
options for no multiple rows? pgsql 04:04
Re: interval and timestamp change? Tom Lane 04:07
Re: LIMIT Optimization Bruce Momjian 04:19
Re: options for no multiple rows? pgsql list 04:33
Re: options for no multiple rows? Stephan Szabo 08:53
Re: options for no multiple rows? Yvo Nelemans 13:13
double quote handling? postgresql 15:54
Re: pltcl build problem on FreeBSD (was: Re: pltlc and Peter Eisentraut 16:02
Re: double quote handling? Peter Eisentraut 16:05
Re: LIMIT Optimization Ross J. Reedstrom 22:31

Jan. 28, 2002

Thread Author Time
Re: LIMIT Optimization Oleg Bartunov 13:26
export/save meta data John 14:15
Re: LIMIT Optimization- please release anything you've got ... :-) Steve Brett 15:00
Re: LIMIT Optimization Ross J. Reedstrom 17:57
Re: PGACCESS installation Jean-Luc Lachance 18:54
Re: options for no multiple rows? Jeff Eckermann 20:00
xbase2pg 1.0-1 vs postgres 7.2b5 compatibility Jean-Luc Lachance 20:31
Re: options for no multiple rows? Allan Engelhardt 21:30
Re: export/save meta data "Allan Engelhardt <\ \\ \"Make me valid\"" 21:35
Re: export/save meta data Allan Engelhardt <""(Use the valid address for non-spam) 21:37
Re: export/save meta data Allan Engelhardt 21:37
plpgsql function with more than one array argument Andre Holzner 23:52

Jan. 29, 2002

Thread Author Time
Again about foreign keys and inheritance Dedov Anton 03:45
get array data with range Johny Jugianto 11:02
Re: get array data with range CoL 15:23
What's wrong with this function - "returns setof" Alla 19:14

Jan. 30, 2002

Thread Author Time
Date Parse Paulo J. Matos 00:04
Re: Date Parse Andrew G. Hammond 00:45
Re: Date Parse postgresql 00:59
Re: Date Parse Chris Ruprecht 01:10
SQL Script 📎 lonh SENG 01:12
Re: [ADMIN] SQL Script David Stanaway 02:08
Re: SQL Script Stephan Szabo 02:14
Re: SQL Script lonh SENG 03:37
Listing Triggers Brian McCane 09:13
psql and macOSX with 7.2b5 postgresql 13:10
Re: psql and macOSX with 7.2b5 Chris Ruprecht 15:10
Re: Listing Triggers Tom Lane 15:57
Re: Listing Triggers Arguile 16:30
Re: Listing Triggers Brian McCane 18:00
Re: Listing Triggers Tom Lane 18:26
Re: Listing Triggers Stephan Szabo 18:31
Re: linking from SQL Server Oleg Lebedev 19:54
Re: psql and macOSX with 7.2b5 Tom Lane 19:54
Difference between Access97 and PostgreSQL Yan Bai 23:54

Jan. 31, 2002

Thread Author Time
Re: Difference between Access97 and PostgreSQL Josh Berkus 00:57
Index Management Paulo J. Matos 01:24
How to merge several attributes and Delete an attribute Yan Bai 07:34
Re: How to merge several attributes and Delete an attribute Christopher Kings-Lynne 07:57
working with sequences Alex Ott 10:43
Re: How to merge several attributes and Delete an attribute Tod McQuillin 12:31
compare with CHAR Tomas Eriksson 13:58
Re: Difference between Access97 and PostgreSQL Roberto Mello 15:31
Regression tests failed on 7.2rc2 Radu-Adrian Popescu 15:36
Re: Regression tests failed on 7.2rc2 Radu-Adrian Popescu 15:51
Re: [SQL] Regression tests failed on 7.2rc2 Peter Eisentraut 16:35
Re: [SQL] Regression tests failed on 7.2rc2 Tom Lane 16:47
Re: working with sequences Tom Lane 16:57
Re: How to merge several attributes and Delete an attribute Annie Bai 19:33
Re: How to merge several attributes and Delete an Josh Berkus 20:35
test the existence of a database D'laila Pereira 20:52

Feb. 1, 2002

Thread Author Time
Re: Difference between Access97 and PostgreSQL Christopher Kings-Lynne 00:29
Re: Difference between Access97 and PostgreSQL Henshall, Stuart - WCP 10:15
Compare with CHAR Tomas Eriksson 12:59
Re: test the existence of a database Steve Brett 13:29
Re: Index Management Steve Brett 13:32
pg_vlock / vacuum 📎 David M. Richter 14:36
syntax for using function parameter in to_char Kevin Barrett 17:57
Re: Compare with CHAR Josh Berkus 19:41
NOTICE: Vacuum: can not process indices, views and certain system tables Diehl, Jeffrey 20:25
Re: Again about foreign keys and inheritance Stephan Szabo 20:36
Re: What's wrong with this function - "returns setof" Tom Lane 20:36
Re: pg_vlock / vacuum Tom Lane 20:39
Re: syntax for using function parameter in to_char Josh Berkus 20:40
Re: NOTICE: Vacuum: can not process indices, views and certain system tables Tom Lane 21:19
Array slice subscripts (was Re: [SQL] plpgsql function with more than one array argument) Tom Lane 21:56

Feb. 2, 2002

Thread Author Time
Fractional Results Paulo J. Matos 01:26
Re: Fractional Results Tom Lane 04:39
casting question A. Van Hook 15:20
Re: test the existence of a database Steve Boyle (Roselink) 16:38
Re: casting question Stephan Szabo 18:58

Feb. 4, 2002

Thread Author Time
temporary tables, plpgsql and yes i bet this has been asked before Murray Prior Hobbs 10:32
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 14:13
Re: casting question Jeff Eckermann 15:05
Re: temporary tables, plpgsql and yes i bet this has been asked before Tom Lane 15:47
Re: temporary tables, plpgsql and yes i bet this has been asked Jan Wieck 20:06
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:15
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:25
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:27
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:39
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:43
Re: temporary tables, plpgsql and yes i bet this has been asked Tom Lane 20:47
Re: temporary tables, plpgsql and yes i bet this has been asked Bruce Momjian 20:50
Re: temporary tables, plpgsql and yes i bet this has been asked Jan Wieck 21:13

Feb. 5, 2002

Thread Author Time
Database ownership Rudi 03:28
Re: Timestamp output Barry Lind 10:59
RULES - Difference between DO and DO INSTEAD Luis Sousa 11:26
Execute some of the elements of the RULE without a plan to the VIEW Luis Sousa 12:18
=?ISO-8859-1?Q?Privil=E9gios_s?=obre colunas Sandro Joel Eller 13:02
Re: Privil?gios sobre colunas Roberto Mello 15:03
WAL filling up disk Roberto Mello 16:54
indexes Isabelle Brette 17:05
Re: WAL filling up disk Chris Ruprecht 17:23
Re: WAL filling up disk Tom Lane 17:28
Re: indexes Chris Ruprecht 17:50
Re: WAL filling up disk Chris Ruprecht 18:00
Re: WAL filling up disk Tom Lane 18:18
Re: RULES - Difference between DO and DO INSTEAD Josh Berkus 18:20
Re: WAL filling up disk Josh Berkus 20:53
Re: WAL filling up disk Tom Lane 21:49
practical limitations to number of postgres user accounts Murray Prior Hobbs 22:37
Re: Database ownership Rudi 22:49

Feb. 6, 2002

Thread Author Time
Re: indexes Isabelle Brette 09:50
Re: indexes Stephan Szabo 15:29
Query with Parameters Evil Azrael 16:53
Re: WAL filling up disk Vivek Khera 17:28
Re: Query with Parameters Ian Barwick 17:57
Re: Query with Parameters Jeff Eckermann 19:24
JOIN between three *simple* tables ... Marc G. Fournier 20:47
Re: JOIN between three *simple* tables ... Tom Lane 21:14
Re: JOIN between three *simple* tables ... Marc G. Fournier 21:41

Feb. 7, 2002

Thread Author Time
type aliases in 7.0.3 Christopher Kings-Lynne 00:46
pg_shadow / pg_user Rudi 01:51
Re: pg_shadow / pg_user Christopher Kings-Lynne 02:05
Re: pg_shadow / pg_user Rudi 02:15
Re: pg_shadow / pg_user Bruce Momjian 02:31
Nested Transactions John Hasler 13:13
Re: Nested Transactions Bruce Momjian 17:00
How do you return more than one variable in a plpgsql function? Mark Nielsen 20:43
Looking for the correct solution for a generic problem. Frank Joerdens 20:52
Re: Looking for the correct solution for a generic problem. Mark Nielsen 20:53
Re: Help with a SQL query Mark Nielsen 21:02
Re: Looking for the correct solution for a generic problem. Stephan Szabo 21:31
Re: Looking for the correct solution for a generic problem. Tom Lane 21:50
Re: Looking for the correct solution for a generic problem. Frank Joerdens 22:04
ALTER TABLE and dropping a column Frank Joerdens 22:25
Re: ALTER TABLE and dropping a column Josh Berkus 23:22

Feb. 8, 2002

Thread Author Time
Re: How do you return more than one variable in a plpgsql function? Vincent AE Scott 02:13
Re: Help with a SQL query Bill Cunningham 03:47
Multiprocessor support for 7.2 📎 David M. Richter 09:05
Re: Multiprocessor support for 7.2 Bruce Momjian 14:02

Feb. 9, 2002

Thread Author Time
Adding a New Composite Constraint to an Existing Table. Bhuvan A 10:28
Re: Adding a New Composite Constraint to an Existing Table. MindTerm 12:57
Re: Adding a New Composite Constraint to an Existing Table. Stephan Szabo 17:43

Feb. 10, 2002

Thread Author Time
SQL Help - multi values James Carrier 06:34
Re: SQL Help - multi values Oleg Bartunov 08:49
Re: SQL Help - multi values Bruno Wolff III 16:04
Re: SQL Help - multi values Greg Sabino Mullane 17:53
Re: SQL Help - multi values Andrew G. Hammond 20:33
Re: SQL Help - multi values David Stanaway 22:43

Feb. 11, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 01:00
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Brent Verner 01:42
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 02:24
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu 📎 Brent Verner 03:49
Sequences Hunter, Ray 13:43
Re: SQL Help - multi values James Carrier 14:17
Re: Sequences Markus Bertheau 14:22
Re: Sequences Bruno Wolff III 14:36
Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 15:07
Re: Sequences Hunter, Ray 15:12
Join Statements T Conti 15:15
Re: Sequences mallah 15:19
Re: Sequences mallah 15:38
Re: Sequences Bruno Wolff III 15:51
Re: Sequences 📎 Chris Ruprecht 17:25
Re: Oracle "Jobs" in PostgreSQL Andrew G. Hammond 17:54
Re: Oracle "Jobs" in PostgreSQL Thomas Good 18:30
UNION and rows improperly unified: query optimization question Henry House 20:05
Support for bulk reads/writes ? charlie 20:06
Re: Support for bulk reads/writes ? Andrew Perrin 20:24
Re: Support for bulk reads/writes ? David Stanaway 22:58

Feb. 12, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 00:49
Re: UNION and rows improperly unified: query optimization question Tom Lane 01:18
help importing external excel file RPI 01:33
obtaining row number of select Keith Keller 02:23
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 04:09
Re: Oracle "Jobs" in PostgreSQL David Stanaway 04:30
Sequencing Problem in Transaction.. Bhuvan A 05:25
Storing text data in databases. mallah 05:39
Re: Sequencing Problem in Transaction.. Christopher Kings-Lynne 06:02
Re: Storing text data in databases. Christopher Kings-Lynne 06:04
Re: Sequencing Problem in Transaction.. Stephan Szabo 06:21
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 06:56
Re: Sequencing Problem in Transaction.. Bhuvan A 13:40
SQL request to retrieve the type of columns Jean-Max Reymond 15:45
Re: SQL request to retrieve the type of columns Vivek Khera 15:52
Re: Storing text data in databases. Josh Berkus 16:22
Re: Sequencing Problem in Transaction.. Bruce Momjian 17:16
Re: SQL request to retrieve the type of columns Andrew G. Hammond 17:40
pg_atoi error Oleg Lebedev 21:08
Re: pg_atoi error Oleg Lebedev 21:35
Re: UNION and rows improperly unified: query optimization question Jean-Luc Lachance 22:49

Browse Archives

Prev | Next