pgsql-sql before 2003-02-01 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Jan. 22, 2003

Thread Author Time
Re: Speed depending of Join Order. Tom Lane 20:24
Re: To use a VIEW or not to use a View..... Stephan Szabo 21:09
Re: To use a VIEW or not to use a View..... Tom Lane 21:35
Re: sort by relevance Björn Metzdorf 21:43
Re: To use a VIEW or not to use a View..... Tomasz Myrta 21:54

Jan. 23, 2003

Thread Author Time
Re: To use a VIEW or not to use a View..... Stephan Szabo 00:45
Re: To use a VIEW or not to use a View..... Stephan Szabo 00:52
Re: To use a VIEW or not to use a View..... Tom Lane 01:01
DBCC CheckIdent in a stored proc? smoghe 01:14
Re: CREATE VIEW ERROR Igor 05:00
Re: To use a VIEW or not to use a View..... Ries van Twisk 08:08
Re: PostgreSQL + SSL Bhuvan A 10:14
Re: DBCC CheckIdent in a stored proc? Bhuvan A 10:17
Re: To use a VIEW or not to use a View..... Tomasz Myrta 10:49
calling function from rule Tambet Matiisen 10:51
Slow query Ricardo Javier Aranibar León 14:16
Re: Slow query Tomasz Myrta 14:43
Re: calling function from rule Tom Lane 15:30
Re: calling function from rule Tambet Matiisen 15:55
Re: To use a VIEW or not to use a View..... Stephan Szabo 16:53
Re: calling function from rule Tom Lane 17:00
Re: To use a VIEW or not to use a View..... Tom Lane 17:21
Re: To use a VIEW or not to use a View..... jasiek 17:46
Re: To use a VIEW or not to use a View..... Stephan Szabo 18:21
SQL to list databases? Ben Siders 18:56
Re: To use a VIEW or not to use a View..... Tom Lane 19:54
checking data integrity in a recursive table Luke Pascoe 20:19
Re: SQL to list databases? Larry Rosenman 20:30
Re: SQL to list databases? Kristopher Yates 20:33
Re: SQL to list databases? Steve Crawford 21:24
Rename database? Wei Weng 22:01
Re: SQL to list databases? Keith Keller 22:43

Jan. 24, 2003

Thread Author Time
Scheduling Events? David Durst 00:16
Re: cannot create function that uses variable table name Beth 00:25
plpgsql: debugging Oliver Vecernik 02:38
Re: Scheduling Events? Ed L. 02:39
CAST from VARCHAR to INT Luke Pascoe 02:56
Re: SQL to list databases? Horst Herb 02:58
Re: Rename database? codeWarrior 03:47
Re: SQL to list databases? Roberto Mello 03:52
Re: Scheduling Events? Roberto Mello 05:06
Re: CAST from VARCHAR to INT Bhuvan A 05:58
Re: CAST from VARCHAR to INT Tom Lane 06:01
quastions about primary key jack 06:44
Re: Scheduling Events? David Durst 07:13
Re: plpgsql: debugging Ludwig Lim 07:41
Race condition w/ FIFO Queue reappears! Chris Gamache 07:58
Creating tables from within functions Seethalakshmi VB 08:36
Re: calling function from rule Tambet Matiisen 08:39
Re: Scheduling Events? David Durst 08:45
Re: quastions about primary key Tomasz Myrta 10:04
Re: CAST from VARCHAR to INT daq 10:28
Re: Scheduling Events? Achilleus Mantzios 11:13
Re: Scheduling Events? Bruno Wolff III 13:29
Re: Scheduling Events? Achilleus Mantzios 13:52
Re: quastions about primary key Stephan Szabo 15:14
Re: Scheduling Events? Tom Lane 15:32
Re: CAST from VARCHAR to INT Tom Lane 15:42
Re: Scheduling Events? Wei Weng 15:55
Re: SQL to list databases? Guy Fraser 18:26
Re: Scheduling Events? Guy Fraser 18:46
Re: CAST from VARCHAR to INT Roberto Mello 19:03
Getting multiple rows in plpgsql function David Durst 19:39
Re: Scheduling Events? David Durst 21:19
Re: Getting multiple rows in plpgsql function Roberto Mello 22:36
Function for adding Money type David Durst 23:41

Jan. 25, 2003

Thread Author Time
Re: Function for adding Money type Josh Berkus 00:17
Re: Function for adding Money type David Durst 01:30
Re: Getting multiple rows in plpgsql function Guy Fraser 01:42
Filter function Evgen Potemkin 12:06

Jan. 26, 2003

Thread Author Time
Re: quastions about primary key jack 02:29
Re: returning setof in plpgsql Bruce Momjian 03:51
Re: quastions about primary key Bruno Wolff III 04:23
ERROR: Cannot display a value of type RECORD David Durst 08:41
Re: ERROR: Cannot display a value of type RECORD David Durst 08:49
Re: [SQL] Function for adding Money type Thomas Good 13:48
Re: [SQL] Function for adding Money type D'Arcy J.M. Cain 13:53
Re: [SQL] Function for adding Money type Oliver Elphick 16:03
Re: Scheduling Events? Matthew Nuzum 19:52
Re: PostgreSQL + SSL Bruce Momjian 23:15

Jan. 27, 2003

Thread Author Time
how sub queries and joins differs funcationally shreedhar 06:59
Re: [ADMIN] how sub queries and joins differs funcationally Ludwig Lim 07:36
Re: how sub queries and joins differs funcationally Ludwig Lim 07:52
Please include hier-patch in next PostgreSQL version Boris Klug 15:05
Re: Rename database? Bruce Momjian 18:41
sequence question Marie G. Tuite 20:06
Re: CAST from VARCHAR to INT Luke Pascoe 20:11
Re: [SQL] Function for adding Money type Bruce Momjian 20:14
Re: sequence question Rod Kreisler 20:17

Jan. 28, 2003

Thread Author Time
Cross-table constraints Rodger Donaldson 07:05
converting microsoft sql server 2000 sql-code for postgresql 7.2.1 william windels 10:08
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Geraint Jones 10:27
Re: converting microsoft sql server 2000 sql-code for postgresql Bhuvan A 11:16
subselect return in where clause Michael Hostbaek 11:21
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Rajesh Kumar Mallah. 11:58
import error Oliver Vecernik 13:26
Re: CR/LF conversion (was: import error) Oliver Vecernik 14:08
CSV import Oliver Vecernik 14:46
Re: import error Tom Lane 15:28
Re: CR/LF conversion (was: import error) Tom Lane 15:32
double linked list Juergen 15:44
Re: subselect return in where clause Tom Lane 15:56
Re: double linked list DA Morgan 16:45
Re: import error Achilleus Mantzios 17:43
Re: import error Achilleus Mantzios 17:47
Re: CR/LF conversion (was: import error) Achilleus Mantzios 18:20
Re: CSV import Achilleus Mantzios 19:01
Cross-database references Pedro Igor Craveiro e Silva 19:30
Problem with query Ricardo Javier Aranibar León 21:00
Re: converting microsoft sql server 2000 sql-code for postgresql Guy Fraser 21:58
Re: CSV import Guy Fraser 22:13
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Jeff Eckermann 22:36
Re: Cross-database references Jason Turner 22:37
Re: CSV import Jeff Eckermann 22:45
Re: double linked list --CELKO-- 23:54

Jan. 29, 2003

Thread Author Time
LONG - Question on dealing w/ numerics David Durst 00:54
Re: Cross-database references Roberto Mello 01:28
Re: CSV import Jean-Luc Lachance 01:50
Re: converting microsoft sql server 2000 sql-code for postgresql Tom Lane 01:55
Re: Problem with query Tom Lane 02:18
Re: Problem with query Josh Berkus 02:45
Re: LONG - Question on dealing w/ numerics Josh Berkus 02:50
Re: LONG - Question on dealing w/ numerics Josh Berkus 02:54
Re: CSV import Rodger Donaldson 03:13
Re: LONG - Question on dealing w/ numerics Tom Lane 04:08
extracting constraints from schema Agnieszka Rutkowska 04:25
Re: converting microsoft sql server 2000 sql-code for postgresql Wei Weng 04:39
Re: CSV import Oliver Vecernik 05:50
Re: Cross-table constraints Stephan Szabo 06:03
Re: Cross-table constraints Rodger Donaldson 06:11
Re: Cross-table constraints Stephan Szabo 06:13
Re: Creating tables from within functions Stephan Szabo 06:44
USING INDEX Abdul Wahab Dahalan 07:27
COPY use in function with variable file name Sondaar Roelof 08:05
Re: Creating tables from within functions Sondaar Roelof 08:16
Re: Filter function Tom Lane 08:25
Re: Cross-table constraints Bruno Wolff III 08:28
Re: converting microsoft sql server 2000 sql-code for postgresql Bruno Wolff III 08:31
Re: LONG - Question on dealing w/ numerics Tom Lane 09:01
Re: LONG - Question on dealing w/ numerics David Durst 09:17
plpgsql: return results of a dynamic query Moritz Lennert 09:21
Re: CSV import Gary Stainburn 10:04
returning table from a function Seethalakshmi VB 10:52
Re: double linked list Juergen 12:12
Re: plpgsql: return results of a dynamic query Christoph Haller 13:00
Re: Please include hier-patch in next PostgreSQL version Rod Taylor 13:17
Re: plpgsql: return results of a dynamic query Moritz Lennert 13:24
help: triggers Tony Simbine 13:29
Re: double linked list Jan Hidders 13:48
Re: help: triggers Wei Weng 15:55
Inheritence and Integrity Neal Lindsay 19:56
Re: Inheritence and Integrity Stephan Szabo 20:19
Re: Inheritence and Integrity Neal Lindsay 20:39
Re: Inheritence and Integrity Stephan Szabo 20:49
Re: double linked list --CELKO-- 21:15
Re: double linked list Ryan 21:30

Jan. 30, 2003

Thread Author Time
Re: Inheritence and Integrity chester c young 06:27
Re: help: triggers Tony Simbine 08:20
Re: Filter function Evgen Potemkin 08:27
Question about passing User defined types to functions David Durst 10:18
Delete 1 Record of 2 Duplicate Records val 11:52
Re: double linked list Christoph Haller 13:10
Re: double linked list Christoph Haller 14:26
Re: double linked list Alan Gutierrez 14:30
Function executing twice Thiago Conti 14:54
Re: Filter function Tom Lane 14:56
Re: Delete 1 Record of 2 Duplicate Records greg 15:04
Re: Function executing twice Tambet Matiisen 15:15
Re: Question about passing User defined types to functions Christoph Haller 15:29
Re: Question about passing User defined types to functions Tom Lane 15:39
calculated expressions and index use Pavel Hlavnicka 15:54
Re: Delete 1 Record of 2 Duplicate Records Achilleus Mantzios 16:00
Re: calculated expressions and index use Arjen van der Meijden 16:13
Re: calculated expressions and index use Tom Lane 16:51
Re: double linked list --CELKO-- 19:13
Converting clarion Nasair Junior da Silva 20:36
Re: CSV import Chad Thompson 20:48
Re: CSV import Oliver Vecernik 22:31
Re: Converting clarion Oliver Vecernik 22:38

Jan. 31, 2003

Thread Author Time
How to rename and drop a column in pg7.3? Vernon Wu 01:15
Re: Delete 1 Record of 2 Duplicate Records Tom Lane 01:16
FW: Converting clarion Michael Weaver 02:19
Re: How to rename and drop a column in pg7.3? mallah 02:58
Re: checking data integrity in a recursive table Bruce Momjian 05:32
design review, FreshPorts change Dan Langille 05:33
how can i convert a substring to a date? joe.guyot 07:03
Re: calculated expressions and index use Pavel Hlavnicka 08:44
Postgres MD5 Function David Durst 09:34
Index File growing big. PRAGATI SAVAIKAR 11:29
Controlling access to Sequences Matthew Horoschun 12:47
Server access thru webmin Huub 14:42
Re: calculated expressions and index use Tom Lane 14:56
Re: CSV import Jean-Luc Lachance 15:27
how do i create a date from a substring??? joe.guyot 15:40
Re: calculated expressions and index use Pavel Hlavnicka 16:03
Which version is this? Wei Weng 16:43
Help with a query for charting Andrew Veitch 17:55
Re: Postgres MD5 Function Larry Rosenman 18:14
Re: Postgres MD5 Function Joe Conway 19:32
For each record in SELECT Luis Magaña 21:21

Browse Archives

Prev | Next