pgsql-sql since 2004-12-14 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. 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
Re: failed to find conversion function from "unknown" to text Tom Lane 17:20
Re: Syntax error while altering col-type Rosser Schwarz 17:22
Re: failed to find conversion function from "unknown" to text Andrew Sullivan 17:23
Re: Problems with HAVING Sam Mason 17:40
Re: Problems with HAVING Michael Fuhr 17:41
Recursive query to be used in another result ? Bradley Miller 17:53
Problems with Quotes Kieran Ashley 18:08
Re: Problems with Quotes John DeSoi 18:17
Re: Problems with Quotes Kieran Ashley 18:28
Re: Problems with HAVING Kaloyan Iliev Iliev 18:39
Re: Problems with HAVING Kaloyan Iliev Iliev 18:40
Re: Problems with Quotes Edmund Bacon 18:46
Re: Problems with Quotes Michael Fuhr 18:58
Re: Problems with Quotes Kieran Ashley 19:00
Re: Problems with Quotes John DeSoi 19:40

Jan. 13, 2005

Thread Author Time
Re: Implementing queue semantics (novice) KÖPFERL Robert 08:43
Re: Syntax error while altering col-type KÖPFERL Robert 08:48
Re: Syntax error while altering col-type Sam Mason 10:19
Columns into rows. Dawid Kuroczko 10:26
Re: Columns into rows. Dawid Kuroczko 10:45
Re: Columns into rows. Dawid Kuroczko 11:31
RE RE: Single row tables KÖPFERL Robert 11:39
Re: Syntax error while altering col-type Andrew Sullivan 12:05
Re: Syntax error while altering col-type KÖPFERL Robert 12:30
Re: Syntax error while altering col-type Andrew Sullivan 13:25
Column with recycled sequence value KÖPFERL Robert 17:08
Re: Column with recycled sequence value Andrew Sullivan 19:49
Re: Column with recycled sequence value Bruno Wolff III 20:16
Re: Column with recycled sequence value Scott Marlowe 20:48
Re: Column with recycled sequence value Michael Fuhr 21:19
Re: Column with recycled sequence value Scott Marlowe 21:31
Re: Column with recycled sequence value Andrew Sullivan 21:43
Re: Column with recycled sequence value Michael Fuhr 21:47
Re: Column with recycled sequence value Scott Marlowe 21:57
Re: Column with recycled sequence value Andrew Sullivan 22:14

Jan. 14, 2005

Thread Author Time
Re: Column with recycled sequence value PFC 01:27
pgmirror Theo Galanakis 02:19
Re: Column with recycled sequence value Greg Stark 05:06
Re: Column with recycled sequence value KÖPFERL Robert 09:09
Trick to 'run' a view on two databases and combine the result ? Din Adrian 09:52
Re: Trick to 'run' a view on two databases and combine the result ? Michael Fuhr 10:43
Re: Column with recycled sequence value (solved (somehow)) KÖPFERL Robert 18:44
assign the row count of a query to a variable Kevin B. 20:43
Re: assign the row count of a query to a variable PFC 21:13
I am writing a MS SQL server conversion utility and am having an issue with timestamp Joel Fradkin 21:15
Re: assign the row count of a query to a variable Michael Fuhr 21:15

Jan. 15, 2005

Thread Author Time
Re: SQL Query Performance tips PFC 08:26
Re: return value of the trigger function Bruno Wolff III 09:00
Split pg_dump script 📎 Markus Schaber 12:54
SQL design question: null vs. boolean values j.random.programmer 14:40
Re: SQL design question: null vs. boolean values Andrew Sullivan 15:05
Re: SQL design question: null vs. boolean values Richard Huxton 15:09

Jan. 16, 2005

Thread Author Time
Re: I am writing a MS SQL server conversion utility and am having an issue with timestamp Michael Fuhr 01:50
plpgsql and for with integer loopvar error Ari Kahn 03:43

Browse Archives

Prev | Next