pgsql-sql - June 2004

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
Jump to day: 1 2 3 4 6 7 8 9 10 11 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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
Re: search and replace Benoît BOURNON 08:16
Re: (No Subject) Franco Bruno Borghesi 14:02
pg_dump inside function (was: Re: (No Subject)) Martin Knipper 14:23
plpgsql - Insert from a record variable? Phil Endecott 14:42

June 14, 2004

Thread Author Time
Re: Datetime problem Achilleus Mantzios 13:34
Datetime problem Eric Lemes 14:08
Re: Datetime problem Stef 14:31
Re: Datetime problem Tom Lane 14:56
max value from join hook 16:02
RES: Datetime problem Eric Lemes 16:20
query with =ALL Jaime Casanova 16:49
a query with = ALL Jaime Casanova 17:06
Re: RES: Datetime problem Alexander M. Pravking 17:10
Re: query with =ALL Stephan Szabo 17:38
Re: query with =ALL Richard Huxton 17:48
Re: query with =ALL Jaime Casanova 18:01
Re: query with =ALL Jaime Casanova 18:06
Re: max value from join Richard Poole 18:26
Re: query with =ALL Stephan Szabo 18:26
Re: RES: Datetime problem Tom Lane 18:47
Re: a query with = ALL Tom Lane 18:51
Re: RES: Datetime problem Tom Lane 19:02
Re: query with =ALL Jaime Casanova 19:07
Re: a query with = ALL Jaime Casanova 19:11
Scalar subqueries Subbiah, Stalin 19:33
Scalar subqueries Subbiah, Stalin 19:38
Re: query with =ALL Tom Lane 19:41
Re: query with =ALL Jaime Casanova 19:53
Re: query with =ALL Tom Lane 19:55
Re: query with =ALL Jaime Casanova 20:04
Re: query with =ALL Stephan Szabo 20:07
Re: Scalar subqueries Richard Poole 20:44
Prepare Statement Jie Liang 23:32

June 15, 2004

Thread Author Time
Re: Last insert id Andrei Bintintan 07:05
Re: Last insert id Rod Taylor 10:30
Number of rows effected Pankaj Chugh 12:28
Re: [SQL] Prepare Statement Jie Liang 16:44
Re: Prepare Statement Kris Jurka 18:00
Is there a faster way to do this? Patrick Hatcher 18:55
Re: Is there a faster way to do this? Richard Huxton 20:17
Re: Is there a faster way to do this? Edmund Bacon 20:20
Re: Is there a faster way to do this? Jean-Luc Lachance 20:38

June 16, 2004

Thread Author Time
Re: Last insert id Michalis Kabrianis 06:47
Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc) Stijn Vanroye 07:27
How to delete the not DISTINCT ON entries Christoph Haller 11:52
Re: How to delete the not DISTINCT ON entries Achilleus Mantzios 12:18
Re: How to delete the not DISTINCT ON entries Jean-Luc Lachance 14:14
Inheritance, plpgsql inserting, and revisions Phil Endecott 15:12
help with Postgres function ctrl 21:49

June 17, 2004

Thread Author Time
Re: Prepare Statement Jie Liang 00:53
Re: Is there a faster way to do this? Greg Sabino Mullane 03:03
Re: Prepare Statement Kris Jurka 04:30
use of a composite type in CREATE TABLE? Hannes Korte 11:01
Re: Optimal query suggestion needed Richard Huxton 13:36
Re: use of a composite type in CREATE TABLE? Tom Lane 13:37
Optimal query suggestion needed Interzone 14:46
Re: Optimal query suggestion needed Bruno Wolff III 17:54
Re: Prepare Statement Jie Liang 18:18
Re: Prepare Statement Kris Jurka 18:59
Re: Optimal query suggestion needed InterZone 19:06
Re: Optimal query suggestion needed InterZone 19:22
Re: Optimal query suggestion needed Bruno Wolff III 20:01
Re: Prepare Statement Jie Liang 20:54
Re: Prepare Statement Kris Jurka 22:25
Re: Prepare Statement Jie Liang 22:50

June 18, 2004

Thread Author Time
Re: Prepare Statement Jie Liang 03:09
Re: Prepare Statement Kris Jurka 05:47
Re: Prepare Statement Kris Jurka 05:51
Re: Prepare Statement Jie Liang 16:43
Re: Prepare Statement Jie Liang 16:52
In 7.4 ensure you have DEFAULT now () with no spaces David B 18:29
case stement when null Jaime Casanova 21:38
Re: Prepare Statement Kris Jurka 21:47
Re: Prepare Statement Kris Jurka 21:47
Re: Prepare Statement Oliver Jowett 23:07

June 19, 2004

Thread Author Time
Re: plpgsql - Insert from a record variable? Riccardo G. Facchini 06:03
Re: case stement when null Riccardo G. Facchini 06:21
Re: case stement when null V i s h a l Kashyap @ [Sai Hertz And Control Systems] 10:20
Re: In 7.4 ensure you have DEFAULT now () with no spaces Peter Eisentraut 12:25
Re: plpgsql - Insert from a record variable? Tom Lane 18:39
Re: In 7.4 ensure you have DEFAULT now () with no spaces Tom Lane 18:50

June 20, 2004

Thread Author Time
pivot-like transformation Torsten Lange 19:44
question about which column(s) are the right foreign key Markus Bertheau 21:22
Re: pivot-like transformation Joe Conway 22:15

June 21, 2004

Thread Author Time
Re: use of a composite type in CREATE TABLE? Josh Berkus 04:48
Re: question about which column(s) are the right foreign key Josh Berkus 04:57
Re: help with Postgres function Stephan Szabo 05:35
Function Parameters - need help !!! Pradeepkumar, Pyatalo (IE10) 06:21
Strange behaviour updating primary key column. Luis Neves 06:29
Re: pivot-like transformation Torsten Lange 08:08
feature request sad 08:48
Re: Function Parameters - need help !!! V i s h a l Kashyap @ [Sai Hertz And Control Systems] 09:42

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30