pgsql-sql since 2004-05-16 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

May 16, 2004

Thread Author Time
Re: How to speed up a time dimension query Gaetano Mendola 11:42

May 17, 2004

Thread Author Time
Re: a wierd query sad 07:12
Re: a wierd query Stijn Vanroye 07:25
Re: a wierd query Stijn Vanroye 07:31
problem with spanish characters Freddy Villalba Arias 08:02
Re: a wierd query Stijn Vanroye 09:24
Re: [JDBC] problem with spanish characters nahum castro 14:05
Re: view running query Andrew Hammond 14:32
Replace function ... Kornelije 14:58
Re: a wierd query Stephan Szabo 15:01
Max Columns in a SQL Select PS PS 16:37
Re: Unique Constraint with foreign Key Karsten Hilbert 16:51
Re: Max Columns in a SQL Select Richard Huxton 18:06
Re: Replace function ... Yasir Malik 19:34

May 18, 2004

Thread Author Time
Re: a wierd query Stijn Vanroye 07:56
Any sql repository T Ullas 08:26
Opening and Fetching from a refcursor inside a function kumar 12:18
Very slow search using basic pattern matching Dan Field 15:47
Re: Very slow search using basic pattern matching Bruno Wolff III 16:12
I'm baffled hook 16:19
Re: How to speed up a time dimension query Hans de Bruin 16:56
Re: Very slow search using basic pattern matching Karsten Hilbert 17:15
Re: I'M Sorry! Ricardo Maia 18:30
Using "Without OIDs" Richard Huxton 18:56

May 19, 2004

Thread Author Time
Re: Replace function ... Benoît BOURNON 10:24
Re: a wierd query Christoph Haller 10:55
Re: Very slow search using basic pattern matching Dan Field 11:33
Re: Very slow search using basic pattern matching Raphael A. Bauer 11:51
Preventing Deletions with triggers Jeff Post 14:19
Function valid only for one table Martin Knipper 14:42
Re: Function valid only for one table Richard Huxton 16:33
SCHEMA's the easy way? Chris Gamache 16:38
Re: SCHEMA's the easy way? Tom Lane 17:00
Re: Function valid only for one table Martin Knipper 17:09
rules Jie Liang 17:20
Re: Replace function ... Kornelije Rabuzin 17:30
Re: Replace function ... Kornelije Rabuzin 17:31
Re: Function valid only for one table Tom Lane 17:33
Re: Function valid only for one table Martin Knipper 17:41
Re: rules Jie Liang 17:41
Re: [SQL] rules Stephan Szabo 17:50

May 20, 2004

Thread Author Time
where to start with this procedure ? Andreas 00:33
Re: where to start with this procedure ? Andrei Bintintan 07:17
Re: where to start with this procedure ? Andreas 14:46
Re: where to start with this procedure ? Stephan Szabo 15:01
XML data field LSanchez 15:58
OR clause causing strange index performance Doug Y 17:32
Simple view confuses PostgreSQL query planning Manuel Sugawara 17:33
Re: OR clause causing strange index performance Doug Y 17:46
v7.2 triggers and foreign keys Paul Gimpelj 18:32
Re: Simple view confuses PostgreSQL query planning Tom Lane 19:06
Re: Simple view confuses PostgreSQL query planning Manuel Sugawara 21:43

May 21, 2004

Thread Author Time
Re: OR clause causing strange index performance Tom Lane 06:53
Problem with JOINS Charlie Clark 07:28
Re: v7.2 triggers and foreign keys Richard Huxton 08:11
Re: Preventing Deletions with triggers Achilleus Mantzios 08:30
Re: XML data field Richard Huxton 10:36
Re: Problem with JOINS Stephan Szabo 14:17
Re: Preventing Deletions with triggers Manuel Sugawara 15:01
Re: Problem with JOINS Tom Lane 15:05
Re: Preventing Deletions with triggers Tom Lane 15:28

May 22, 2004

Thread Author Time
Memory usage on subselect Alexander M. Pravking 17:54

May 23, 2004

Thread Author Time
Re: Memory usage on subselect Tom Lane 16:28
Re: Memory usage on subselect Alexander M. Pravking 18:32

May 24, 2004

Thread Author Time
Re: Memory usage on subselect Dan Field 08:53
Re: Memory usage on subselect Tom Lane 13:37

May 26, 2004

Thread Author Time
Multitable uniqueness ? Andreas 03:13
trigger function building hook 11:42
Re: Multitable uniqueness ? Bruno Wolff III 12:20
Re: Multitable uniqueness ? Jan Wieck 13:56
Re: Multitable uniqueness ? Jean-Luc Lachance 14:00
Re: trigger function building Manuel Sugawara 15:20
Re: Memory usage on subselect Dan Field 15:51
Re: Memory usage on subselect Gaetano Mendola 16:29

May 27, 2004

Thread Author Time
Re: The PostgreSQL sad 03:56
Re: Multitable uniqueness ? Andreas 07:07
Re: Multitable uniqueness ? Andreas 07:22
Re: sum ( time) problem Willem de Jong 11:14
Re: Multitable uniqueness ? Jean-Luc Lachance 13:08
PostgreSQL is hanging up !? Louie Kwan 20:43

May 28, 2004

Thread Author Time
type regclass casting sad 09:29
insert or update violates foreign key constraint.why? Oleg Mayevskiy 13:49
Re: OR clause causing strange index performance Atesz 15:37
Re: not really SQL but I need info on BLOBs Jared Evans 16:40
About intervals Pablo Velasquez Rivas 18:27
Re: About intervals Bruno Wolff III 21:23

May 30, 2004

Thread Author Time
multi results with functions kasper 22:02
Re: multi results with functions CoL 22:13

May 31, 2004

Thread Author Time
passing new/old record in pl/pgsql trigger functions to other functions basic 05:51
Re: passing new/old record in pl/pgsql trigger functions to other functions Tom Lane 06:14
type regclass casting sad 07:52
joining a table with a function Jaime Casanova 14:19

June 1, 2004

Thread Author Time
Re: insert or update violates foreign key constraint.why? Tom Lane 02:05
assistance on self join pls email lists 12:29
Schemata & User-Defined-Type casting issues Chris Gamache 14:00
Re: sum ( time) problem Bruno Wolff III 14:03
Re: Schemata & User-Defined-Type casting issues Tom Lane 14:25
Query becoming slower on adding a primary key mallah 19:21
Re: Query becoming slower on adding a primary key Tom Lane 21:36

June 2, 2004

Thread Author Time
most efficient way to manage ordering Matthew Nuzum 02:35
Re: most efficient way to manage ordering Rod Taylor 03:10
Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah 08:50
UNIQUE columnt depdening on other column??? Andrei Bintintan 11:39
Re: UNIQUE columnt depdening on other column??? Richard Huxton 12:21
Re: UNIQUE columnt depdening on other column??? Reinoud van Leeuwen 12:43
Re: assistance on self join pls Rajesh Kumar Mallah 13:48
function with a composite type calling another function - Mission Impossible? Riccardo G. Facchini 14:52
Re: function with a composite type calling another function - Mission Impossible? Tom Lane 15:43
Re: function with a composite type calling another function - Mission Impossible? Riccardo G. Facchini 15:55

June 3, 2004

Thread Author Time
Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah 05:03
Re: bytea or blobs? Richard Huxton 07:19
Reference with condition on other table column? Andrei Bintintan 09:16
Re: Date format problems Stef 12:12
Re: Date format problems Richard Huxton 12:14
Re: Reference with condition on other table column? Stephan Szabo 14:24
Re: [SQL] SQL Spec Compliance Questions Enrico Weigelt 17:19
Re: [SQL] SQL Spec Compliance Questions Enrico Weigelt 17:20
Re: ORDER BY TIMESTAMP_column ASC, NULL first Bruno Wolff III 17:31
Selecting "sample" data from large tables. Joseph Turner 17:31
Re: [SQL] SQL Spec Compliance Questions elein 18:06
Re: Reference with condition on other table column? Bruno Wolff III 18:20
Re: Selecting "sample" data from large tables. Tom Lane 18:27
Re: [SQL] SQL Spec Compliance Questions Enrico Weigelt 18:45
Formatting problems with negative intervals, TO_CHAR Jeff Boes 20:03
Re: [SQL] SQL Spec Compliance Questions elein 20:41
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 23:09

June 4, 2004

Thread Author Time
dynamic rules? Christopher Dedels 04:32
Re: Selecting "sample" data from large tables. Greg Stark 06:11
ERROR: duplicate key violates unique constraint Khairul Azmi 08:06
Difference between two times as a numeric value in a stored procedure. Stijn Vanroye 08:11
trigger data hook 13:06
Re: Difference between two times as a numeric value in a stored procedure. Tom Lane 14:11
Re: Difference between two times as a numeric value in a stored procedure. [Scanned] Stijn Vanroye 14:44
Re: Difference between two times as a numeric value in a stored procedure. Bruno Wolff III 15:23
Re: dynamic rules? Bruno Wolff III 16:13
Re: ERROR: duplicate key violates unique constraint Josh Berkus 17:05
Re: dynamic rules? Bruno Wolff III 18:18
Re: [SQL] SQL Spec Compliance Questions elein 18:33
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 19:20
ANSI SQL-99 SYNTAX and "WITH" Rein Petersen 19:37
Re: ANSI SQL-99 SYNTAX and "WITH" Yasir Malik 19:51
Re: ANSI SQL-99 SYNTAX and "WITH" Bruno Wolff III 20:02
Re: ANSI SQL-99 SYNTAX and "WITH" Tom Lane 20:43

June 6, 2004

Thread Author Time
Re: create function atof? Yasir Malik 02:16
SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior Neil Zanella 08:19
Re: postgresql multiple insert slow Harald Fuchs 11:39
Re: SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior Tom Lane 22:37
Re: Formatting problems with negative intervals, TO_CHAR Tom Lane 22:40

June 7, 2004

Thread Author Time
Re: ERROR: duplicate key violates unique constraint (SOLVED) Khairul Azmi 03:22
Re: sum ( time) problem Willem de Jong 06:09
empty string casting to typed value sad 06:37
Re: Formatting problems with negative intervals, TO_CHAR Karel Zak 07:52
Re: Formatting problems with negative intervals, TO_CHAR Stefan Weiss 09:08
Re: Formatting problems with negative intervals, TO_CHAR Karel Zak 09:46
Re: empty string casting to typed value Bruno Wolff III 13:59
Re: empty string casting to typed value Stephan Szabo 14:34
Re: pl/pgsql and transaction locks Marcus Whitney 18:24
Getting FK relationships from information_schema Kyle 23:57

June 8, 2004

Thread Author Time
Cursor returned from procedure ignores setFetchSize() on CallableStatement Brian G. Huber 05:40
Re: Getting FK relationships from information_schema Tom Lane 05:53
Re: Getting FK relationships from information_schema Kyle 15:13
Re: Query becoming slower on adding a primary key Rajesh Kumar Mallah 18:41
Re: Trigger problem Mike Rylander 18:57
Trigger problem kasper 19:38
simple addition of constraints problem Michelle Murrain 21:51
a query question Jaime Casanova 22:05
Re: [SQL] simple addition of constraints problem Richard Poole 22:55
Re: simple addition of constraints problem Stephan Szabo 23:18

June 9, 2004

Thread Author Time
Re: Getting FK relationships from information_schema Tom Lane 05:04
Last insert id mixo 06:24
Re: Getting FK relationships from information_schema Peter Eisentraut 06:36
Re: Last insert id mkl 06:54
Re: Last insert id Richard Huxton 07:22
Re: returning a recordset from PLpg/SQL Richard Huxton 08:58
Re: Triggers Richard Huxton 09:01
Schema + User-Defined Data Type Indexing problems... Chris Gamache 16:41
search and replace Jodi Kanter 17:30
Re: Trigger problem Stephan Szabo 20:30

June 10, 2004

Thread Author Time
Re: Trigger problem Jan Wieck 01:44
Re: Schema + User-Defined Data Type Indexing problems... Tom Lane 04:21
Re: Getting FK relationships from information_schema Tom Lane 06:32
Find out whether a view's column is indexed? Martin Schäfer 07:56
Re: Find out whether a view's column is indexed? Richard Huxton 08:41
Re: Schema + User-Defined Data Type Indexing problems... Chris Gamache 13:20
Re: Find out whether a view's column is indexed? Martin Schäfer 13:48
Converting integer to binary Stephen Quinney 13:52
Re: Find out whether a view's column is indexed? Karsten Hilbert 14:06
Re: Schema + User-Defined Data Type Indexing problems... Tom Lane 14:09
Re: Schema + User-Defined Data Type Indexing problems... Chris Gamache 14:34
Function returns error Michael Long 15:01
Re: Function returns error Richard Huxton 15:38
Re: Schema + User-Defined Data Type Indexing problems... Tom Lane 15:40
Re: query optimization Franco Bruno Borghesi 15:45
Re: Converting integer to binary Bruno Wolff III 18:27
Re: Converting integer to binary Chris Gamache 20:24
Re: Converting integer to binary Bruno Wolff III 22:27

June 11, 2004

Thread Author Time
(No Subject) William Anthony Lim 04:36
Re: Query becoming slower on adding a primary key [ SOLVED Rajesh Kumar Mallah 04:59
casting int to bit sad 07:32
Re: Converting integer to binary Stephen Quinney 07:54

Browse Archives

Prev | Next