Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - March 2000

2000-03-01

• 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)

2000-03-02

• 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)

2000-03-03

• 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)

2000-03-04

• 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)

2000-03-05

• 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)

2000-03-06

• 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)

2000-03-07

• 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)

2000-03-08

• 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)

2000-03-09

• 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)

2000-03-30

• [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)

2000-03-31

• 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)
• Stored Procedures.. S Kalyanasundaram (22:47)