pgsql-sql since 2004-12-19 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. 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
Re: SQL design question: null vs. boolean values j.random.programmer 13:59
Re: SQL design question: null vs. boolean values PFC 18:47
Re: pgmirror Theo Galanakis 23:07

Jan. 17, 2005

Thread Author Time
Re: TEXT type blob extraction in ecpg KÖPFERL Robert 07:33
Record type in sql Din Adrian 12:31
Re: Record type in sql KÖPFERL Robert 12:48
Inserting or Deleting conditionally KÖPFERL Robert 15:25
Re: Inserting or Deleting conditionally Richard Huxton 16:02
query configuration for validate empty quote to zero Yudie 18:44
Re: query configuration for validate empty quote to zero Tom Lane 19:23
Re: query configuration for validate empty quote to zero Yudie 19:30
Re: plpgsql and for with integer loopvar error Stephan Szabo 19:38
"How do I ..." SQL question zeus 23:31

Jan. 18, 2005

Thread Author Time
Re: "How do I ..." SQL question PFC 00:13
mail + rfc822, rfc2822 + schema Achilleus Mantzios 15:05
Returning a bool on DELETE in a proc. KÖPFERL Robert 16:04
Re: query configuration for validate empty quote to zero KÖPFERL Robert 16:17
Re: Returning a bool on DELETE in a proc. Keith Worthington 18:46
Re: Returning a bool on DELETE in a proc. Michael Fuhr 18:52
postgres stored procedures Joel Fradkin 20:18
URGENT: Using function inside query Bradley Miller 20:51

Jan. 19, 2005

Thread Author Time
Re: "How do I ..." SQL question Bob 03:11
Re: mail + rfc822, rfc2822 + schema Ron Peterson 03:46
Re: URGENT: Using function inside query Michael Fuhr 06:39
Looking for examples of S/P KÖPFERL Robert 09:03
Re: Looking for examples of S/P Michael Fuhr 09:48
Re: Returning a bool on DELETE in a proc. KÖPFERL Robert 10:24
Re: Returning a bool on DELETE in a proc. Richard Huxton 12:16
Re: mail + rfc822, rfc2822 + schema Achilleus Mantzios 12:21
Re: Looking for examples of S/P RobertD.Stewart 12:34
converting Oracle scripts to PostgreSQL Gary Broadbent 12:37
Re: Returning a bool on DELETE in a proc. Karsten Hilbert 13:18
Re: Looking for examples of S/P John DeSoi 14:19
Conversion ideas (Views/procedures) Joel Fradkin 15:23
Re: Conversion ideas (Views/procedures) KÖPFERL Robert 15:50
Re: Returning a bool on DELETE in a proc. Michael Fuhr 17:01
Re: Returning a bool on DELETE in a proc. KÖPFERL Robert 17:09
Re: Conversion ideas (Views/procedures) Keith Worthington 17:32
ERROR: row is too big: size 9856, maximum size 8136 Joel Fradkin 20:50
Re: Returning a bool on DELETE in a proc. Michael Fuhr 21:35
include in both ecpg and C++ none none 22:03

Jan. 20, 2005

Thread Author Time
Re: ERROR: row is too big: size 9856, maximum size 8136 Michael Fuhr 03:01
Query performance and understanding explain analzye Benjamin Wragg 04:05
SQL timestamp to date cast Andrei Bintintan 08:52
Re: SQL timestamp to date cast Michael Fuhr 09:33
Problem on Geometric functions Silke Trissl 09:39
Re: SQL timestamp to date cast Andrei Bintintan 09:41
Re: SQL timestamp to date cast Michael Fuhr 09:51
Re: Problem on Geometric functions Michael Fuhr 10:04

Browse Archives

Prev | Next