pgsql-sql since 2004-12-07 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

Dec. 7, 2004

Thread Author Time
Insert successful but data not found Mian Yong Leow 02:58
Re: Making dirty reads possible? Pierre-Frédéric Caillaud 08:27

Dec. 8, 2004

Thread Author Time
Unresolved external: tgetent Christoph Haller 12:50
Indexing Strategy Matthew Engelbert 19:21

Dec. 9, 2004

Thread Author Time
filtering Kevin B. 15:25
parse error at or near "(" -- Huh??? Alex Beamish 20:19

Dec. 10, 2004

Thread Author Time
Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 11:40
Cast NULL into Timestamp? Wei Weng 19:24
Create Calendar Muhyiddin A.M Hayat 19:26
Re: Indexing Strategy Josh Berkus 23:42

Dec. 11, 2004

Thread Author Time
Re: Cast NULL into Timestamp? Steve Crawford 00:10
Re: Cast NULL into Timestamp? Stephan Szabo 00:48
Re: Indexing Strategy Matthew Engelbert 00:57
Re: Query is not using index when it should Stephan Szabo 02:28
Re: Create Calendar Michael Fuhr 04:11
replacing mysql enum Kenneth Gonsalves 05:00
Re: Cast NULL into Timestamp? Josh Berkus 05:11
Re: Create Calendar Joe Conway 11:55
Re: replacing mysql enum Ian Barwick 12:25
PREPARED STATEMENT NosyMan 12:47
Re: Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 14:17
Re: [GENERAL] Query is not using index when it should Steinar H. Gunderson 14:32
Re: replacing mysql enum Stephan Szabo 15:47
Re: [GENERAL] Query is not using index when it should Michael Fuhr 16:25
Re: replacing mysql enum Rod Taylor 16:35
Re: replacing mysql enum Stephan Szabo 16:45
Re: replacing mysql enum Ian Barwick 17:06
Re: Cast NULL into Timestamp? Frank Bax 17:10
Re: replacing mysql enum Greg Stark 17:25
Re: replacing mysql enum Tom Lane 17:56
Re: replacing mysql enum Josh Berkus 18:16
Re: filtering Bruno Wolff III 19:01

Dec. 12, 2004

Thread Author Time
Re: [GENERAL] Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 08:32

Dec. 13, 2004

Thread Author Time
Re: Insert successful but data not found Michael Fuhr 02:12
Re: parse error at or near "(" -- Huh??? Michael Fuhr 02:18
Re: parse error at or near "(" -- Huh??? Tom Lane 02:45
Re: Query is not using index when it should Josh Berkus 02:48
Re: Unresolved external: tgetent Bruce Momjian 03:13
Re: parse error at or near "(" -- Huh??? Alex Beamish 03:43
Re: parse error at or near "(" -- Huh??? Kenneth Gonsalves 03:57
Re: parse error at or near "(" -- Huh??? D'Arcy J.M. Cain 08:44
Hide schemas and tables Markus Schaber 10:25
mysql set datatype Kenneth Gonsalves 11:01
Re: Unresolved external: tgetent Christoph Haller 12:01
postgressql.org Christoph Haller 12:48
Re: Hide schemas and tables John DeSoi 13:16
Re: Hide schemas and tables Richard Huxton 13:18
Re: mysql set datatype Richard Huxton 13:25
Re: mysql set datatype Kenneth Gonsalves 13:43
Re: postgressql.org Christopher Browne 16:35
Re: Unresolved external: tgetent Tom Lane 17:00
Similar tables, different indexes performance 📎 Alvaro Nunes Melo 17:17
Re: Similar tables, different indexes performance Bruno Wolff III 18:03
Re: Similar tables, different indexes performance Alvaro Nunes Melo 19:32

Dec. 14, 2004

Thread Author Time
Re: Similar tables, different indexes performance Bruno Wolff III 05:22

Dec. 15, 2004

Thread Author Time
Re: Indexing Strategy Josh Berkus 02:29
Updating column to link one table to another Mark Collette 10:07
Join issue? Marian POPESCU 15:10
Join issue? Marian POPESCU 15:21
Re: Join issue? Stephan Szabo 15:46
[Fwd: Majordomo results: unsubscribe] Jodi Kanter 16:01
Re: [SQL] [Fwd: Majordomo results: unsubscribe] Richard Huxton 16:17
Breadth first traversal in PLSQL (How to implement Queue?) Richard Rowell 18:54

Dec. 16, 2004

Thread Author Time
Re: Breadth first traversal in PLSQL (How to implement Queue?) Mike Rylander 02:48
Re: Breadth first traversal in PLSQL (How to implement Queue?) Mike Rylander 03:23
Re: Breadth first traversal in PLSQL (How to implement Queue?) Andrew - Supernews 03:37
Query aid Roberto Fichera 10:34
question about index Jerome Alet 10:41
Re: [despammed] question about index Andreas Kretschmer 11:01
Re: Query aid Janning Vygen 11:21
Re: question about index D'Arcy J.M. Cain 11:30
Re: Query aid Roberto Fichera 11:41
Re: [despammed] question about index Bruno Wolff III 14:10
Re: [despammed] question about index Andreas Kretschmer 14:15
get branches & childs from database Marcus Krause 21:23
plpgsql.. SELECT INTO ... WHERE FIELD LIKE Yudie 23:53

Dec. 17, 2004

Thread Author Time
Re: plpgsql.. SELECT INTO ... WHERE FIELD LIKE Michael Fuhr 00:46
Re: plpgsql.. SELECT INTO ... WHERE FIELD LIKE Christopher Browne 03:08
Re: plpgsql.. SELECT INTO ... WHERE FIELD LIKE Christopher Browne 03:33
FUNCTION, TRIGGER and best practices Keith Worthington 04:05
Re: FUNCTION, TRIGGER and best practices Josh Berkus 05:43
Table History Richard Sydney-Smith 06:23
Re: FUNCTION, TRIGGER and best practices Michael Fuhr 06:52
can't get the order I want after inserting new rows Marcus Claesson 09:46
sql can i substitute Kenneth Gonsalves 11:25
Re: [despammed] sql can i substitute Andreas Kretschmer 11:45
Re: [despammed] sql can i substitute Kenneth Gonsalves 12:18
Re: [despammed] sql can i substitute Andreas Kretschmer 12:24
Re: can't get the order I want after inserting new rows Richard Huxton 12:37
Re: sql can i substitute D'Arcy J.M. Cain 12:42
Re: sql can i substitute Kenneth Gonsalves 12:52
Re: [despammed] sql can i substitute Kenneth Gonsalves 13:01
Re: [despammed] sql can i substitute Achilleus Mantzios 14:08
Re: can't get the order I want after inserting new rows Marcus Claesson 14:32
Re: sql can i substitute Bruno Wolff III 14:56
Re: sql can i substitute Bruno Wolff III 15:01
Re: Table History John DeSoi 15:37
Re: Table History RobertD.Stewart 15:51
Re: can't get the order I want after inserting new rows Richard Huxton 16:43

Dec. 18, 2004

Thread Author Time
Re: get branches & childs from database Michael Fuhr 09:26
diff databases drdani 14:23
Revoke on all database Henry Molina 17:54
Re: Revoke on all database Kretschmer Andreas 19:08

Dec. 19, 2004

Thread Author Time
Question about geometric function area() Kretschmer Andreas 10:38
Re: Question about geometric function area() Kretschmer Andreas 14:52

Dec. 20, 2004

Thread Author Time
Re: Updating column to link one table to another Richard Huxton 09:13
I'm stumped Doug Y 16:30
Date datatype Pablo Digonzelli 23:41

Dec. 21, 2004

Thread Author Time
Re: diff databases Theo Galanakis 05:25
Re: Date datatype Együd Csaba (Freemail) 06:18
Re: Date datatype Achilleus Mantzios 08:38
linux clusters and pgsql Kenneth Gonsalves 09:59
Re: Date datatype Iain 10:07
Re: linux clusters and pgsql Richard Huxton 11:16
commit inside plpgsql function Dennis Sacks 17:21
commit in plpgsql function? Dennis Sacks 17:34
Re: commit in plpgsql function? Gregory S. Williamson 21:08
Re: I'm stumped thomas.silvi 22:39

Dec. 22, 2004

Thread Author Time
Re: I'm stumped Iain 01:42
Unable to execute Java Progarm 📎 Anil Kumar 12:07

Dec. 24, 2004

Thread Author Time
save sql result to file william lim 04:44
Re: save sql result to file Guy Fraser 16:30
Re: commit inside plpgsql function Gregory S. Williamson 22:18

Dec. 26, 2004

Thread Author Time
Function in C++ Jose Mendoza 18:23

Dec. 27, 2004

Thread Author Time
Get current trasanction id Marek Lewczuk 08:52
Re: [SQL] Get current trasanction id Achilleus Mantzios 10:38
Re: Get current trasanction id Martijn van Oosterhout 12:07
Re: Get current trasanction id Michael Fuhr 14:54
Re: Get current trasanction id Marek Lewczuk 19:54

Dec. 28, 2004

Thread Author Time
simulating global temp tables in plpgsql functions Dennis Sacks 00:20
Re: Get current trasanction id Joachim Zobel 15:05
Re: Get current trasanction id Marek Lewczuk 15:51
Making a prepared statement in a stored procedure Nathan Pickett 17:12
Problem with subquery containg GROUP BY Ishay Pomerantz 17:31

Dec. 29, 2004

Thread Author Time
Re: diff databases Robert Treat 03:35

Dec. 30, 2004

Thread Author Time
Making a prepared statement in a stored procedure Nathan Pickett 15:01

Dec. 31, 2004

Thread Author Time
Formatting an Interval Jamison Roberts 16:37
Re: Formatting an Interval Michael Fuhr 19:41

Jan. 1, 2005

Thread Author Time
Re: Function in C++ TJ O'Donnell 19:20

Jan. 2, 2005

Thread Author Time
one table being used for two purposes with foreign key for each? Miles Keaton 10:05
Re: Formatting an Interval Karel Zak 16:19
Re: Formatting an Interval Michael Fuhr 16:39
Re: Formatting an Interval Kretschmer Andreas 16:46
Re: Formatting an Interval Pierre-Frédéric Caillaud 17:09

Jan. 3, 2005

Thread Author Time
Re: Formatting an Interval Edmund Bacon 23:02

Jan. 4, 2005

Thread Author Time
foreign key problems 📎 12:15
Re: foreign key problems Stephan Szabo 14:56

Jan. 5, 2005

Thread Author Time
Calling a table in another database from plpgsql deepthi 03:30
Re: Calling a table in another database from plpgsql Kris Jurka 04:45
Calling a table residing in another database from Plpgsql deepthi 05:13
Re: Calling a table residing in another database from Plpgsql Kenneth Gonsalves 05:38
Re: foreign key problems 09:30
Re: Calling a table residing in another database from Plpgsql CoL 12:50
Re: foreign key problems Stephan Szabo 13:29
Re: foreign key problems Stephan Szabo 13:32
Re: Calling a table in another database from plpgsql Dave Cramer 13:48
Re: Calling a table residing in another database from Plpgsql Joe Conway 14:54
Re: Calling a table in another database from plpgsql Kris Jurka 15:37
Re: Calling a table residing in another database from Plpgsql Kretschmer Andreas 16:28
plpsql function problem drdani 19:45
Re: plpsql function problem Tom Lane 20:53
undigested email TJ O'Donnell 21:31

Jan. 6, 2005

Thread Author Time
vararg plpsql function drdani 07:32

Jan. 7, 2005

Thread Author Time
View with Union and update rule - fails Filip Jirsák 11:10
simulating row ownership Rick Schumeyer 16:52
Re: View with Union and update rule - fails Tom Lane 18:29
Re: simulating row ownership Michael Fuhr 20:06

Jan. 9, 2005

Thread Author Time
Question about insert/update RULEs. Dmitri Bichko 11:45
Easier way to 'strip' on multiple matches? Marc G. Fournier 18:32

Jan. 10, 2005

Thread Author Time
SQL Query Performance tips Michael Ossareh 10:00
return value of the trigger function Jarek Pudełko 14:15
TEXT type blob extraction in ecpg none none 17:43
TEXT blob extraction in ecpg none none 18:02
Re: TEXT blob extraction in ecpg Michael Fuhr 21:09

Jan. 11, 2005

Thread Author Time
Re: Question about insert/update RULEs. Ron Peterson 02:14
Parsing a Calculation from a field Kieran Ashley 11:20
Re: Parsing a Calculation from a field Richard Huxton 11:35
Re: simulating row ownership Ron Peterson 13:38
Re: simulating row ownership Ron Peterson 13:40
Single row tables KÖPFERL Robert 14:45
Re: Single row tables Dmitri Bichko 14:50
Re: Parsing a Calculation from a field Kieran Ashley 14:50
Re: Parsing a Calculation from a field Jeff Eckermann 14:50
Re: Single row tables KÖPFERL Robert 15:17
Simple Question Terry Lee Tucker 21:42
Re: Simple Question Guy Fraser 22:06
Re: Simple Question Terry Lee Tucker 22:07
Re: Simple Question Michael Fuhr 22:15
Re: Simple Question Terry Lee Tucker 22:18
Re: Simple Question Stephan Szabo 22:21
Re: Simple Question Terry Lee Tucker 22:21
Re: Simple Question Tom Lane 22:43

Jan. 12, 2005

Thread Author Time
Re: Single row tables sad 06:39
Implementing queue semantics (novice) KÖPFERL Robert 13:54
Re: Implementing queue semantics (novice) Andrew Hammond 16:18
Problems with HAVING Kaloyan Iliev Iliev 16:38
failed to find conversion function from "unknown" to text Szűcs Gábor 16:52
Syntax error while altering col-type KÖPFERL Robert 17:02
Re: Problems with HAVING Michael Fuhr 17:11
Re: Syntax error while altering col-type Michael Fuhr 17:17

Browse Archives

Prev | Next