pgsql-sql since 2003-01-02 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Jan. 2, 2003

Thread Author Time
Re: Slow self-join on a 100 million record table Paul Thornett 03:30
bug? Minghann Ho 04:36
Re: empty arrays Tom Lane 06:04
Re: Slow self-join on a 100 million record table Tom Lane 06:06
Re: bug? Tom Lane 06:16
Re: Reference integrity question Stephan Szabo 09:42
PostgreSQL X Resin EE Pedro Igor 13:16
Re: empty arrays Steve Crawford 19:06
Adding a Primary Key to an exisiting table Maly Kaing 21:15
NULLL comparison in multiple column unique index Brian Walker 23:19

Jan. 3, 2003

Thread Author Time
Re: Adding a Primary Key to an exisiting table Bhuvan A 05:20
Re: NULLL comparison in multiple column unique index Manfred Koizar 13:10
Query Pedro Igor 13:46
Re: Query Stephan Szabo 15:57
Compiling pl/pgsql functions? Daniel Bruce Lynes 17:27

Jan. 4, 2003

Thread Author Time
SQL to determine Tablenames, Primarykeys & Foreignkeys] Kevin Gordon 03:57
Re: Reference integrity question Stephan Szabo 15:16

Jan. 5, 2003

Thread Author Time
Deleting in order from a table pginfo 09:26
weighting (the results of) a query ? Peter Galbavy 10:41
Re: Deleting in order from a table Ludwig Lim 12:18

Jan. 6, 2003

Thread Author Time
Grant execute on functions; related objects permissions ? Cédric Dufour (public) 10:12
Re: Grant execute on functions; related objects permissions ? Tambet Matiisen 10:45
order by and aggregate Tomasz Myrta 12:44
Re: order by and aggregate Richard Huxton 13:41
Re: Grant execute on functions; related objects permissions ? Bruno Wolff III 13:50
Re: order by and aggregate Tomasz Myrta 14:09
Sorry, to many clients already cristi 14:12
Re: order by and aggregate dev 15:59
Re: order by and aggregate Tom Lane 16:34
Re: order by and aggregate Tomasz Myrta 16:35
Re: order by and aggregate Tom Lane 16:36
Re: order by and aggregate Tomasz Myrta 16:59
Re: order by and aggregate Tomasz Myrta 17:07
sub-select, view and sum() Gary Stainburn 17:29
Re: Sorry, to many clients already Robert Treat 18:20
Re: sub-select, view and sum() Stephan Szabo 18:31
Re: sub-select, view and sum() Gary Stainburn 22:29

Jan. 7, 2003

Thread Author Time
to_date confusion Richard Rowell 03:58
Re: Sorry, to many clients already Tambet Matiisen 08:46
SQL list table names alviN 10:46
Re: SQL list table names Adam Witney 11:03
Inherancing Nasair Junior da Silva 11:42
Re: [SQL] 7.3.1 index use / performance Tomasz Myrta 12:00
Re: Inherancing Adam Witney 12:02
Re: Inherancing Nasair Junior da Silva 12:09
Re: Inherancing Adam Witney 12:21
A problem about alter table jack 12:53
Re: A problem about alter table Tomasz Myrta 13:31
Re: A problem about alter table jack 14:06
Re: A problem about alter table Tomasz Myrta 14:29
insert rule doesn't see id field Ron Peterson 14:54
Re: insert rule doesn't see id field Ron Peterson 14:57
Re: A problem about alter table Jeff Eckermann 15:07
Re: [PERFORM] 7.3.1 index use / performance Stephan Szabo 15:27
7.3.1 index use / performance Achilleus Mantzios 15:39
Re: insert rule doesn't see id field Tom Lane 16:01
Re: weighting (the results of) a query ? Peter Galbavy 16:04
Re: weighting (the results of) a query ? Tom Lane 16:14
Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios 16:21
Re: weighting (the results of) a query ? Peter Galbavy 16:25
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 16:29
Re: weighting (the results of) a query ? Tom Lane 16:34
Re: weighting (the results of) a query ? Peter Galbavy 16:45
Re: Inherancing Daniel Schuchardt 17:16
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 17:44
Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0 Tom Lane 18:22
Re: 7.3.1 function problem: ERROR: cache lookup failed Joe Conway 18:39
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 18:39
Re: A problem about alter table Achilleus Mantzios 18:41
Re: [SQL] 7.3.1 index use / performance Rod Taylor 18:45
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 19:26
Re: [SQL] [PERFORM] 7.3.1 index use / performance 📎 Achilleus Mantzios 20:27
Re: [SQL] [PERFORM] 7.3.1 index use / performance 📎 Achilleus Mantzios 21:05
7.3.1 function problem: ERROR: cache lookup failed for type 0 Achilleus Mantzios 21:55
Re: 7.3.1 function problem: ERROR: cache lookup failed Achilleus Mantzios 22:32
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios 22:38
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios 22:51
double precision to numeric overflow error Thomas O'Connell 23:12
Re: [SQL] double precision to numeric overflow error Stephan Szabo 23:36

Jan. 8, 2003

Thread Author Time
Re: double precision to numeric overflow error Thomas O'Connell 03:01
Re: double precision to numeric overflow error Tom Lane 04:15
Re: double precision to numeric overflow error Thomas O'Connell 05:36
Re: SQL list table names Alan Gutierrez 09:34
full join in view Tambet Matiisen 11:14
Re: full join in view Tomasz Myrta 13:41
Re: SQL list table names Achilleus Mantzios 13:59
Search and Replace Randy D. McCracken 14:02
to_date() confusion Richard Rowell 14:49
Re: Search and Replace Bruno Wolff III 14:56
Re: to_date() confusion Bruno Wolff III 15:06
Re: Search and Replace Rajesh Kumar Mallah. 15:37
count(*) optimization Nikola Ivacic 16:04
Re: count(*) optimization Nikola Ivacic 16:15
Re: Search and Replace Ross J. Reedstrom 16:18
Re: count(*) optimization Bruno Wolff III 16:22
What benefits can I expect from schemas ? Bob Lapique 16:55
Re: count(*) optimization Nikola Ivacic 17:06
Re: What benefits can I expect from schemas ? Bruce Momjian 17:26
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 17:32
PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. Zengfa Gao 17:43
Re: count(*) optimization Josh Berkus 17:44
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios 17:53
Re: insert rule doesn't see id field Ron Peterson 18:13
Re: [SQL] Search and Replace Randy D. McCracken 20:18

Jan. 9, 2003

Thread Author Time
Re: What benefits can I expect from schemas ? chester c young 02:20
Re: What benefits can I expect from schemas ? Bruce Momjian 02:26
Postgresql Bug List? Wei Weng 04:11
Postgresql Bug List? Wei Weng 04:22
Re: Postgresql Bug List? Bruce Momjian 04:30
Re: Search and Replace Rajesh Kumar Mallah. 05:30
Returning row or rows from function? David Durst 06:21
switching default integer datatype to int8 and "IN (...)" clause postgres 09:24
Re: switching default integer datatype to int8 and "IN (...)" clause Andrew J. Kopciuch 10:30
Re: PostgreSQL X Resin EE Radu-Adrian Popescu 10:42
SQL function parse error ? Radu-Adrian Popescu 11:14
Re: SQL function parse error ? Tomasz Myrta 11:56
Re: SQL function parse error ? Radu-Adrian Popescu 12:43
http://www.postgresql.org site problem Achilleus Mantzios 12:45
Re: SQL function parse error ? Tomasz Myrta 13:22
Re: Postgresql Bug List? Robert Treat 14:18
Re: SQL function parse error ? Tom Lane 14:48
Re: SQL function parse error ? Radu-Adrian Popescu 15:05
Re: SQL function parse error ? Radu-Adrian Popescu 15:22
Re: SQL function parse error ? Radu-Adrian Popescu 15:38
Re: SQL function parse error ? Stephan Szabo 15:47
Re: SQL function parse error ? Tom Lane 15:57
Re: SQL function parse error ? Radu-Adrian Popescu 16:29
Re: SQL function parse error ? Stephan Szabo 17:00
Re: SQL function parse error ? Tom Lane 17:17
Re: SQL function parse error ? Radu-Adrian Popescu 17:37
Re: insert rule doesn't see id field Ron Peterson 19:12
Re: SQL function parse error ? Achilleus Mantzios 19:29
Re: insert rule doesn't see id field dev 19:54
Re: SQL function parse error ? Robert Treat 20:44
Re: insert rule doesn't see id field Ron Peterson 21:50
Re: Search and Replace Ross J. Reedstrom 23:03

Jan. 10, 2003

Thread Author Time
Re: [SQL] Search and Replace Randy D. McCracken 00:15
Re: [SQL] Search and Replace Bruno Wolff III 00:38
Getting sequence value after inserting many rows at a time Maurício Sessue Otta 00:48
Re: Getting sequence value after inserting many rows at a time Bruno Wolff III 01:25
Re: insert rule doesn't see id field Ron Peterson 02:07
Re: insert rule doesn't see id field Tom Lane 04:53
Table Design Questions Chad L 09:08
Re: SQL function parse error ? Radu-Adrian Popescu 09:13
Re: insert rule doesn't see id field Radu-Adrian Popescu 09:31
Re: insert rule doesn't see id field Radu-Adrian Popescu 09:33
Re: SQL function parse error ? Robert Treat 14:26
Re: SQL function parse error ? Tom Lane 14:48
Re: Table Design Questions dev 15:12
Re: insert rule doesn't see id field Ron Peterson 16:27
Re: Table Design Questions Josh Berkus 17:32
Re: noupcol code cleanup Ron Peterson 18:46
function does not exist Dave A. 22:22
Re: function does not exist Ross J. Reedstrom 22:23
Re: function does not exist Josh Berkus 22:26
Select * from users WHERE upper(lastName) = upper('Pringle') Hale Pringle 23:45

Jan. 11, 2003

Thread Author Time
Re: Getting sequence value after inserting many rows at a time Bruno Wolff III 18:45

Jan. 12, 2003

Thread Author Time
Re: switching default integer datatype to int8 and "IN (...)" postgres 00:03
Re: Select * from users WHERE upper(lastName) = Dave Cramer 00:28
Re: Select * from users WHERE upper(lastName) = upper('Pringle') Tom Lane 04:45

Jan. 13, 2003

Thread Author Time
Unique indexes not unique? Jimmy Mäkelä 10:05
Re: Unique indexes not unique? Tomasz Myrta 10:43
Re: Unique indexes not unique? Jimmy Mäkelä 10:56
Re: Unique indexes not unique? Stephan Szabo 12:08
Re: Unique indexes not unique? dev 12:32
Crosstab-style query in pure SQL dev 12:47
Re: Unique indexes not unique? Tom Lane 15:31
Re: Unique indexes not unique? Stephan Szabo 15:58
Re: Unique indexes not unique? Tom Lane 16:12
Re: Crosstab-style query in pure SQL Josh Berkus 17:26
Re: Returning row or rows from function? Stephan Szabo 18:43
Re: to_date confusion Stephan Szabo 18:45
Re: to_date confusion Josh Berkus 18:45
Re: Returning row or rows from function? Tomasz Myrta 18:48
Re: Crosstab-style query in pure SQL dev 19:30
Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. Chris Travers 20:18
assigning values to array elements J Greenbaum 20:25
Re: assigning values to array elements Tom Lane 21:04
Re: assigning values to array elements J Greenbaum 21:11
query speed joining tables Christopher Smith 21:20
Re: query speed joining tables Josh Berkus 21:47
Re: query speed joining tables Christopher Smith 21:56
Re: query speed joining tables Tomasz Myrta 22:01
Re: query speed joining tables Christopher Smith 22:03
Re: insert rule doesn't see id field Ron Peterson 22:11
Re: insert rule doesn't see id field Tom Lane 22:16
Re: Postgresql Bug List? Bruce Momjian 22:18

Jan. 14, 2003

Thread Author Time
Re: assigning values to array elements Bruce Momjian 00:47
Re: query speed joining tables Tomasz Myrta 07:12
Re: full join in view Tambet Matiisen 09:04
Re: full join in view Tomasz Myrta 09:50
Data between different databases Pedro Igor 10:53
Re: full join in view Tambet Matiisen 14:27
database broken ? [email protected] 14:45
Re: database broken ? Tom Lane 15:51
Re: Select * from users WHERE upper(lastName) = upper('Pringle') Andrew Sullivan 16:34
Re: query speed joining tables Josh Berkus 19:38
Re: RFC: A brief guide to nulls Josh Berkus 19:46
Re: full join in view jasiek 20:02

Jan. 15, 2003

Thread Author Time
sort by relevance Serhiy Levchenko 07:44

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31