pgsql-sql since 2000-02-21 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. 21, 2000

Thread Author Time
it wont let me delete jdb371 00:39
Re: [SQL] group by date_part Tom Lane 01:05
Re: [SQL] group by date_part M.Mazurek 02:07
Re: [SQL] Select & Tables X Select & Views Rodrigo Rezende 12:42
rule plan string too big Rodrigo Rezende 15:38
Re: [SQL] Select & Tables X Select & Views Tom Lane 22:27
Re: [SQL] rule plan string too big Peter Eisentraut 23:57

Feb. 22, 2000

Thread Author Time
Procedure and Trigger managment. Perfomance Alexey V. Meledin 10:11
HOWTO create BLOB fields? Thomas Frei 20:05
select returning mysterious null rows webmaster 20:43
pg_group system table Gordon Clarke 21:36

Feb. 23, 2000

Thread Author Time
Re: [SQL] pg_group system table Peter Eisentraut 01:20
SQL Script Question Carolyn Wong 06:32
RE: [SQL] SQL Script Question Andrzej Mazurkiewicz 10:06
Re: [SQL] SQL Script Question Kovacs Zoltan Sandor 12:24
problem with grant/revoke Jerome ALET 13:32
capturing microseconds & computing difference between two dates Robin Keech 14:25
[No subject] Justin Long 14:35
Re: [SQL] capturing microseconds & computing difference between two dates Tom Lane 17:12

Feb. 24, 2000

Thread Author Time
create a database Rolf Staege 08:06
database rights? Engard Ferenc 08:13
PostgreSQL and PHP James Macken 11:06
Re: [SQL] PostgreSQL and PHP Stefano Brozzi 11:37
Re: [SQL] PostgreSQL and PHP Giampiero Raschetti 12:00
Re: [SQL] database rights? Peter Eisentraut 16:21
cache lookup failed Graham Vickrage 17:08
Re: [SQL] cache lookup failed Tom Lane 22:14
how to create index on timestamp field in pre v7 database Alex Howansky 22:27
date_part, too many results? M.Mazurek 22:38
arrays of varchar and " Tim Kane 23:54
Re: [SQL] how to create index on timestamp field in pre v7 database Tom Lane 23:57

Feb. 25, 2000

Thread Author Time
Re: [SQL] date_part, too many results? Tom Lane 00:46
Re: [INTERFACES] arrays of varchar and " Tom Lane 01:03
New Optimizer Behaviour In 7.0b1 Mark Kirkwood 03:03
Re: [INTERFACES] arrays of varchar and " Tom Lane 04:48
DELIVERY FAILURE: User laszlo_acs ([email protected]) not listed in public Name & Address Book Postmaster 05:48
Re: [SQL] how to create index on timestamp field in pre v7 database Moray McConnachie 11:16
Problem - Postgres Running continously Nedu 13:54
INSERT w/o variable names for a SERIAL type? Emils Klotins 13:59
Re: [SQL] INSERT w/o variable names for a SERIAL type? Alessio Bragadini 15:14
Finding missing records... Matthew Hagerty 15:56
Re: [SQL] Finding missing records... Jan Wieck 16:11
Re: [SQL] how to create index on timestamp field in pre v7 database Tom Lane 16:29
Re: missing function datetime() Tom Lane 16:36
Re: [SQL] Finding missing records... Sevo Stille 16:38
Re: [SQL] how to create index on timestamp field in pre v7 database Bruce Momjian 16:54

Feb. 26, 2000

Thread Author Time
Next Employee ID Herbert Rabago Ambos 00:12
New Optimizer Behaviour In 7.0b1 Mark Kirkwood 06:57
SQL query problem Vikrant Rathore 07:46
Re: [SQL] New Optimizer Behaviour In 7.0b1 Tom Lane 08:04
Re: [SQL] New Optimizer Behaviour In 7.0b1 Mark Kirkwood 20:23
Re: [SQL] text -> char Tom Lane 21:27
Re: [SQL] New Optimizer Behaviour In 7.0b1 Tom Lane 23:14

Feb. 27, 2000

Thread Author Time
Nested BEGIN...COMMIT transactions mpg4 02:29
Default sequence values Seth Banks 07:45
Re: [SQL] Default sequence values Tom Lane 07:48
Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut 15:18
Re: [SQL] INSERT w/o variable names for a SERIAL type? Tom Lane 18:29
Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian 18:58
Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian 19:04
Re: [SQL] INSERT w/o variable names for a SERIAL type? Ross J. Reedstrom 19:44
Rule (which multiple actions) problem with history table..... maillist 22:45
Re: [SQL] Rule (which multiple actions) problem with history table..... Tom Lane 23:41
Re: [SQL] Nested BEGIN...COMMIT transactions Peter Eisentraut 23:54
Re: [SQL] New Optimizer Behaviour In 7.0b1 Mark Kirkwood 23:57

Feb. 28, 2000

Thread Author Time
Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut 00:00
Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian 00:19
[SQL] 7.0beta1? Christopher Sawtell 00:36
Re: [SQL] 7.0beta1? Bruce Momjian 02:19
Problems with create table continued... Seth Banks 03:35
SQL query problem Vikrant Rathore 03:49
Re: [SQL] Problems with create table continued... Tom Lane 04:29
Re: [SQL] Problems with create table continued... Ross J. Reedstrom 04:36
SQL query problem Vikrant Rathore 05:40
prob with aggregate and group by - returns multiples George Dau 06:22
Re: [SQL] SQL query problem Tom Lane 07:38
Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane 07:50
Re: [HACKERS] Re: missing function datetime() Tom Lane 16:26
Re: [HACKERS] Re: missing function datetime() Thomas Lockhart 16:26
importing data from a text file Abdul Karim 16:42
Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut 20:24
RE: [SQL] prob with aggregate and group by - returns multiples George Dau 21:58
Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane 22:53
Re: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut 23:19

Feb. 29, 2000

Thread Author Time
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane 05:44
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Thomas Lockhart 05:48
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian 05:59
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Thomas Lockhart 06:48
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut 10:54
RE: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut 11:59
DATE formatting problem again Forgacs Tamas 13:29
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returnsmultiples Thomas Lockhart 14:35
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Don Baccus 14:35
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Tom Lane 14:57
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Tom Lane 16:09
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Peter Eisentraut 16:38
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian 17:19
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian 17:21
Help Me!!!! Elsa Campos 18:30

March 1, 2000

Thread Author Time
Need help on creating index for a query w/ 4 greater-than conditions Fan Chi Kam 01:21
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Christopher Sawtell 03:26
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Thomas Lockhart 06:14
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian 06:18
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Tom Lane 06:29
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Thomas Lockhart 06:46
Newbie question: syntax for using Foreign Key Colin Rothnie 07:18
PGSQL & MYSQL Emmanuel Calatan 07:45
Re: [SQL] PGSQL & MYSQL Oleg Broytmann 09:21
Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Moray McConnachie 09:48
Outer Joins (when?) Rybarczyk Mikolaj 16:27
RE: [SQL] Newbie question: syntax for using Foreign Key Andrzej Mazurkiewicz 16:52
Re: [SQL] Outer Joins (when?) Tom Lane 18:35

March 2, 2000

Thread Author Time
RE: DATE Formating Problem Again Mark Kirkwood 09:54
Re: [SQL] RE: DATE Formating Problem Again Karel Zak - Zakkr 11:10
date_part - multiple values in format? Emils Klotins 15:10
Re: [SQL] date_part - multiple values in format? Tom Lane 15:46

March 3, 2000

Thread Author Time
Re: [SQL] date_part - multiple values in format? Emils Klotins 08:51
7.0beta bug (or feature)? 📎 Kyle Bateman 18:19
Strange error message with 7.0beta1 📎 Kyle Bateman 20:45
ENUM Type 📎 Kyle Bateman 21:37

March 4, 2000

Thread Author Time
dayname() Annamalai G 12:45
Re: [SQL] Strange error message with 7.0beta1 Peter Eisentraut 17:05
Re: [SQL] ENUM Type Peter Eisentraut 17:05

March 5, 2000

Thread Author Time
Left Join Nikolaj Lundsgaard 10:43
Re: [SQL] Left Join Peter Eisentraut 14:15
statistics using SQL Oleg Bartunov 20:00
database with 1000000 rows is very slow David Celjuska 20:11
database with 1000000 rows is very slow David Celjuska 20:21

March 6, 2000

Thread Author Time
dayname() doubt Annamalai G 05:11
default for date/time types Seth Banks 06:28
Re: [SQL] default for date/time types Peter Eisentraut 07:09
Re: [SQL] dayname() doubt Peter Eisentraut 07:12
Re: [SQL] database with 1000000 rows is very slow Peter Eisentraut 07:22
index file's growing big 📎 zoltan.sebestyen 10:10
[No subject] 📎 zoltan.sebestyen 10:11
Re: [SQL] dayname() doubt Karel Zak - Zakkr 10:20
index file's growing big 📎 zoltan.sebestyen 11:23
RE: [SQL] database with 1000000 rows is very slow Justin Long 15:27
Selecting random element? Justin Long 15:31
Returning multiple rows in functions Kief Morris 15:54
Re: [SQL] index file's growing big Ross J. Reedstrom 16:24
Re: [SQL] Returning multiple rows in functions Peter Eisentraut 16:24
Re: [SQL] index file's growing big Karl Denninger 16:46
RE: [SQL] Returning multiple rows in functions Kief Morris 17:16
Re: [SQL] index file's growing big Ross J. Reedstrom 18:02
re: [SQL] Best method 📎 Ray Messier 18:11
datetime conversion to JDBC Wendy L. Fry 20:23

March 7, 2000

Thread Author Time
change owner of database -- answer Zot O'Connor 04:47
Re: [SQL] index file's growing big Tom Lane 07:13
insert default into serial fields? Seth Banks 07:22
MS Access suddenly refusing to deal with pgsql db... and Failing Make Robert Chalmers 07:47
Re: [SQL] insert default into serial fields? Tom Lane 08:36
RE: [SQL] index file's growing big zoltan.sebestyen 12:25
PostgreSQL backed application problem 📎 zoltan.sebestyen 12:57
Autogenerated Unique Index 📎 Antonio W. Lagnada 13:41
RE: [SQL] Autogenerated Unique Index Andrzej Mazurkiewicz 14:30
Re: [SQL] Autogenerated Unique Index 📎 Antonio W. Lagnada 15:05
VarChar(n) 📎 Antonio W. Lagnada 15:10
RE: [SQL] Autogenerated Unique Index Andrzej Mazurkiewicz 15:11
postgreSQL vs mySQL 📎 Antonio W. Lagnada 15:16
Re: [SQL] Autogenerated Unique Index 📎 Antonio W. Lagnada 15:29
Re: [SQL] Autogenerated Unique Index Ross J. Reedstrom 15:32
RE: [SQL] Autogenerated Unique Index Andrzej Mazurkiewicz 15:37
Re: [SQL] Autogenerated Unique Index Trurl McByte 15:37
Re: [SQL] VarChar(n) Trurl McByte 15:44
RE: [SQL] index file's growing big zoltan.sebestyen 16:13
Re: [SQL] postgreSQL vs mySQL Mitch Vincent 16:38
Re: [SQL] Autogenerated Unique Index 📎 Antonio W. Lagnada 16:46
Re: [SQL] Strange error message with 7.0beta1 Bruce Momjian 23:23
Re: [SQL] dayname() doubt Bruce Momjian 23:55
Casts in 7.0 vs 6.5 (was Re: [SQL] 7.0beta bug (or feature)?) Tom Lane 23:59

March 8, 2000

Thread Author Time
Errors loading null dates in 7.0beta1 Colin Rothnie 06:36
Re: [SQL] Errors loading null dates in 7.0beta1 Tom Lane 08:36
FW: [SQL] Errors loading null dates in 7.0beta1 Colin Rothnie 09:12
Re: [SQL] database with 1000000 rows is very slow David Celjuska 11:11
Re: [SQL] database with 1000000 rows is very slow David Celjuska 13:06
Record number... Ed 13:43
Re: FW: [SQL] Errors loading null dates in 7.0beta1 Tom Lane 16:04
Re: Casts in 7.0 vs 6.5 (was Re: [SQL] 7.0beta bug (or feature)?) 📎 Kyle Bateman 16:22
END or COMMIT? Matthew Hagerty 20:00

March 9, 2000

Thread Author Time
Re: [SQL] postgreSQL vs mySQL Mathijs Brands 01:04
"Successfully copied." message when copy fails due to FOREIGN KEY constraint Colin Rothnie 02:52
[No subject] 📎 Guus 12:46

March 30, 2000

Thread Author Time
[TEST] Archives should now work again ... The Hermit Hacker 20:16
Foreign keys Aguinaldo Fagundes Junior 21:21
Re: Optimizing BIG joins ? kaiq 21:26
Re: isnull Joseph Shraibman 22:25
approve VKPts5 subscribe example "Jim Freeman" 22:25
Re: isnull Julie Hunt 22:58
Re: removing a field from a table Julie Hunt 23:06
Re: isnull Joseph Shraibman 23:07

March 31, 2000

Thread Author Time
Re: isnull Tom Lane 00:11
Re: isnull Julie Hunt 01:10
Re: isnull Bruce Momjian 01:43
RE: Loading values in from postgreSQL database into a combo box using PHP Wilson Fletcher 05:16
outer join syntax Sarfaraz Patel 10:56
Novice trouble with plpgsql Alexander Stetsenko 12:23
Re: Novice trouble with plpgsql Patrik Kudo 12:59
Re: outer join syntax Peter Eisentraut 13:55
Sub select.. Ed 21:11

Browse Archives

Prev | Next