pgsql-sql - December 2002

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 9 10 11 12 13 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Dec. 1, 2002

Thread Author Time
SQL99 <search or cycle clause> Evgen Potemkin 18:49

Dec. 2, 2002

Thread Author Time
Need Postgresql Help Atul Pedgaonkar 07:10
Re: Need Postgresql Help Andreas Joseph Krogh 08:42
Need Postgresql Help Atul 08:44
Re: Need Postgresql Help Richard Huxton 10:57
Analyzing the 7.3 SQL92 Schema Christian Gausepohl 16:39
CURRENT_TIMSTAMP 📎 Raymond Chui 16:41
Re: [SQL] CURRENT_TIMSTAMP Joel Burton 18:38
Re: Min and Max Dennis Björklund 18:44
Combining queries while preserving order in SQL - Help! Casey Allen Shobe 18:46
Re: Min and Max Joel Burton 18:46
Re: Accumulative Queries? Joel Burton 19:01
Re: Combining queries while preserving order in SQL - Help! Joel Burton 19:23
Re: Min and Max Jean-Luc Lachance 19:54
Re: [SQL] CURRENT_TIMSTAMP Stephan Szabo 21:27

Dec. 3, 2002

Thread Author Time
Re: Question about slow Select when using 'IN'. Tom Lane 07:06
EXIST / NOT EXIST Rachel.Vaudron 08:01
Re: EXIST / NOT EXIST Philip Warner 08:05
Re: EXIST / NOT EXIST Achilleus Mantzios 08:18
Re: EXIST / NOT EXIST Rachel.Vaudron 08:48
Re: EXIST / NOT EXIST Rachel.Vaudron 08:50
recreating table and foreign keys Tomasz Myrta 09:03
Re: Date trunc in UTC Thrasher 09:30
Re: recreating table and foreign keys Tomasz Myrta 12:29
SQL QUERY Pedro Igor 12:43
Re: SQL QUERY Achilleus Mantzios 13:05
[OT] Inventory systems (private) Ries van Twisk 13:17
Re: [OT] Inventory systems (private) Troy 14:46
Re: SQL QUERY Achilleus Mantzios 14:47
problem with view in 7.3 Alphasoft 14:48
Re: [OT] Inventory systems (private) Andy Tawse 14:52
problem with view in 7.3 Alphasoft 15:04
Re: [OT] Inventory systems (private) Ries van Twisk 15:06
Re: [OT] Inventory systems (private) Dan MacNeil 15:07
Re: problem with view in 7.3 Tom Lane 15:18
Backend message type 0x50 arrived while idle Berman, Phil 15:47
Large Query Question. (Slow Select while using 'IN') Mike Winter 16:30
Re: recreating table and foreign keys Stephan Szabo 16:31
Query for filtering records eric soroos 19:01
Re: Query for filtering records Joel Burton 19:47
Re: Query for filtering records Jean-Luc Lachance 19:53
Re: recreating table and foreign keys Stephan Szabo 19:55
Re: import sql script mark carew 20:49
Re: Query for filtering records eric soroos 20:52

Dec. 4, 2002

Thread Author Time
sql query Vijay Uppal 02:03
Re: How does postgres handle non literal string values Vernon Wu 05:22
loop query results Stefan Reuschke 08:58
Re: loop query results Dennis Björklund 09:21
Re: How does postgres handle non literal string values Charles H. Woloszynski 13:00
Problem with view in PostgreSQl 7.3 📎 Alphasoft 14:40
Re: How does postgres handle non literal string values Vernon Wu 17:11
Query about table and catalog javier garcia 18:08
Inheritance in PostgreSQL limitation Pedro Igor 19:19
Re: problem with view in 7.3 Tom Lane 20:02
Ran out of connections Mike Diehl 22:08
Re: Ran out of connections Roberto Mello 22:25
Re: Ran out of connections Steve Crawford 22:29
Re: Ran out of connections Robert Treat 23:23
Re: Ran out of connections Mike Diehl 23:52

Dec. 5, 2002

Thread Author Time
Re: Ran out of connections Roberto Mello 00:00
Re: Ran out of connections Steve Crawford 00:25
Regarding boolean datatype kanika singh 09:11
Re: Backend message type 0x50 arrived while idle Thrasher 09:27
Re: Query about table and catalog Christoph Haller 09:44
Re: Regarding boolean datatype Richard Huxton 10:29
Re: Regarding boolean datatype kanika singh 11:04
Re: master-detail relationship and count Ross J. Reedstrom 19:38

Dec. 6, 2002

Thread Author Time
Case-insensitive Pedro Igor 12:33
Re: Case-insensitive Richard Huxton 13:11
Accent-insensitive Pedro Igor 13:30
Rules/Trigges Trade-offs Jean-Luc Lachance 16:03
Re: Rules/Trigges Trade-offs Richard Huxton 16:31
Re: Rules/Trigges Trade-offs Bruce Momjian 16:34
Re: Rules/Trigges Trade-offs Jean-Luc Lachance 17:30
Re: Rules/Trigges Trade-offs Bruce Momjian 17:41
order by a "select as" determined by case statement FatTony 18:05
Re: order by a "select as" determined by case statement Stephan Szabo 18:16
SELECT FOR UPDATE locks whole table D'Arcy J.M. Cain 19:03
Re: SELECT FOR UPDATE locks whole table Bruce Momjian 19:10
Re: Accent-insensitive Cédric Dufour (public) 20:33
Re: Accent-insensitive Joel Burton 22:17
Re: SELECT FOR UPDATE locks whole table Tom Lane 23:00
Re: Rules/Trigges Trade-offs Josh Berkus 23:25
Re: Rules/Trigges Trade-offs Bruce Momjian 23:30
Re: Rules/Trigges Trade-offs Josh Berkus 23:54

Dec. 7, 2002

Thread Author Time
Re: Rules/Trigges Trade-offs Bruce Momjian 02:24
Re: Rules/Trigges Trade-offs Bruce Momjian 03:43
Re: [SQL] SELECT FOR UPDATE locks whole table D'Arcy J.M. Cain 13:17
Re: Accent-insensitive Joel Burton 21:19

Dec. 9, 2002

Thread Author Time
adding a GROUP BY to an outer join Dan Langille 03:38
Default Permissions (repost from Novice) Michael Weaver 06:51
sql cristi 10:40
Re: sql Richard Huxton 12:04
ISNULL FUNCTION Héctor Iturre 14:30
ISNULL FUNCTION Héctor Iturre 14:30
Re: ISNULL FUNCTION Ludwig Lim 14:42
Adding foreign key constraint post table creation Charles Hauser 16:11
Re: Rules/Trigges Trade-offs Jean-Luc Lachance 16:11
Re: Default Permissions (repost from Novice) Richard Huxton 16:28
Re: Rules/Trigges Trade-offs Josh Berkus 20:06
Re: Rules/Trigges Trade-offs Josh Berkus 20:40
Re: Rules/Trigges Trade-offs Josh Berkus 20:48
Problem with a lookup table! Please help. Chris Jewell 20:58
Re: [OT] Inventory systems (private) Troy 21:01
Re: Problem with a lookup table! Please help. Josh Berkus 21:08
Re: Problem with a lookup table! Please help. Jean-Luc Lachance 21:34
Re: Problem with a lookup table! Please help. Chris Jewell 22:21

Dec. 10, 2002

Thread Author Time
Re: ISNULL FUNCTION 2000 Informática 01:53
Re: Problem with a lookup table! Please help. Oliver Elphick 02:07
SQL syntax for concating values in different rows together Elizabeth O'Neill's Office Mail 12:27
Re: SQL syntax for concating values in different rows together Roberto Mello 16:10
Re: SQL syntax for concating values in different rows together Joe Conway 18:31

Dec. 11, 2002

Thread Author Time
is numeric relational operator problem fixed in v7.3 jack 02:54
Re: is numeric relational operator problem fixed in v7.3 Oliver Elphick 03:08
Question Jonathan Man 06:44
Re: Question Christoph Haller 08:57
Re: sql query Christoph Haller 09:06
Re: Question II Christoph Haller 09:56
Re: Adding foreign key constraint post table creation Richard Huxton 09:58
Problem with timestamp Beatrice Yueksel 10:42
Re: Problem with timestamp Henshall, Stuart - Design & Print 11:03
Re: Backup to data base how ? Frank Bax 15:57
union query doubt: javier garcia 16:21
Re: union query doubt: Frank Bax 16:39
Re: union query doubt: Jean-Luc Lachance 16:57
trigger to maintain relationships David M 17:07
Re: trigger to maintain relationships David M 17:35
error in copy table from file 17:40
Getting the latest unique items A.M. 18:15
Re: error in copy table from file Stephan Szabo 18:20
Re: Getting the latest unique items Tomasz Myrta 18:36
Re: error in copy table from file Manfred Koizar 18:59
multi-user and multi-level database access Tomasz Myrta 23:55

Dec. 12, 2002

Thread Author Time
Re: trigger to maintain relationships Josh Berkus 01:02
Backup to data base how ? ksql 03:36
Re: convert NULL into a value Bruce Momjian 04:03
Re: convert NULL into a value Ludwig Lim 04:03
convert NULL into a value Jonathan Man 04:08
Re: Getting the latest unique items A.M. 05:14
Re: Getting the latest unique items Tom Lane 07:13
Re: Primary Key Help ! Ludwig Lim 08:04
primary + foreign key Huub 08:29
Re: Getting the latest unique items Tomasz Myrta 08:34
Re: primary + foreign key Tomasz Myrta 08:54
Re: primary + foreign key Huub 09:02
Re: primary + foreign key Tomasz Myrta 09:52
Re: primary + foreign key Huub 09:54
Performance Problems Héctor Iturre 12:56
Re: Stored Procedure Problem Christoph Haller 13:37
Stored Procedure Problem Atul 13:41
Re: Stored Procedure Problem Héctor Iturre 13:43
Re: Performance Problems Philip Warner 14:09
Re: Performance Problems Christoph Haller 14:29
Re: Stored Procedure Problem Atul 14:43
Re: Stored Procedure Problem Tomasz Myrta 14:51
Performance Problems Héctor Iturre 15:08
Re: primary + foreign key Roberto Mello 16:27
Re: Stored Procedure Problem Roberto Mello 16:33
function replace doesnt exist Andy Morrow 16:34
Re: function replace doesnt exist Jean-Luc Lachance 16:48
ON DELETE CASCADE Tim Perdue 17:01
Re: ON DELETE CASCADE Stephan Szabo 17:11
Re: ON DELETE CASCADE Marie G. Tuite 17:26
Re: ON DELETE CASCADE Dan Langille 18:17
Re: primary + foreign key Bret Hughes 18:22
Re: function replace doesnt exist Jeff Eckermann 20:24
client for solaris Aravind Vinnakota 21:41
Re: client for solaris Neil Conway 23:04

Dec. 13, 2002

Thread Author Time
Re: function replace doesnt exist Rajesh Kumar Mallah. 10:56
Re: Stored Procedure Problem Rajesh Kumar Mallah. 11:01
order by and limit with multi-column index, bug? Harald Krake 14:34
Re: order by and limit with multi-column index, bug? Jakub Ouhrabka 14:47
Re: order by and limit with multi-column index, bug? Harald Krake 14:52
server terminated by a query in 7.3 Jie Liang 17:29
UPDATE comparing dates and non-dates data javier garcia 17:43
Re: server terminated by a query in 7.3 Frank van Vugt 17:47
A PL/PgSQL Question Ludwig Lim 17:50
Re: server terminated by a query in 7.3 Tom Lane 18:12
A Costly function + LIMIT Chris Gamache 18:14
Re: A Costly function + LIMIT Tom Lane 18:20
Re: server terminated by a query in 7.3 Jie Liang 18:33
Re: A PL/PgSQL Question Josh Berkus 19:41
Re: UPDATE comparing dates and non-dates data Josh Berkus 20:56
Re: UPDATE comparing dates and non-dates data Bret Hughes 21:32

Dec. 16, 2002

Thread Author Time
Re: ON DELETE CASCADE Tim Perdue 02:29
working around setQuerySnapshot limitations in functions Robert Treat 16:23
CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Ludwig Lim 16:41
Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Michael Paesold 16:56
UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) javier garcia 18:57

Dec. 17, 2002

Thread Author Time
Re: working around setQuerySnapshot limitations in functions Jakub Ouhrabka 00:12
Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) Christoph Haller 09:34
join and dynamic view Gary Stainburn 10:58
Re: join and dynamic view Christoph Haller 12:06
Re: join and dynamic view Gary Stainburn 12:23
Re: join and dynamic view Christoph Haller 13:06
Re: join and dynamic view Gary Stainburn 13:09
Re: join and dynamic view Tomasz Myrta 13:36
Re: join and dynamic view Christoph Haller 13:45
Re: join and dynamic view Gary Stainburn 14:11
Re: join and dynamic view Tomasz Myrta 14:12

Browse Archives

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