pgsql-sql since 2004-06-03 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
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 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
subselect prob in view Gary Stainburn 10:10
Re: Strange behaviour updating primary key column. Richard Huxton 10:14
Re: Function Parameters - need help !!! Pradeepkumar, Pyatalo (IE10) 10:48
Re: Function Parameters - need help !!! Phil Endecott 11:52
Re: Function Parameters - need help !!! Richard Huxton 11:54
Re: subselect prob in view Tom Lane 14:19
Re: subselect prob in view Gary Stainburn 15:11
Re: Prepare Statement Jie Liang 16:28
Re: plpgsql - Insert from a record variable? Phil Endecott 17:23
Re: plpgsql - Insert from a record variable? Phil Endecott 18:51

June 22, 2004

Thread Author Time
Re: plpgsql - Insert from a record variable? basic 00:57
Re: plpgsql - Insert from a record variable? Tom Lane 01:30
Re: subselect prob in view Gary Stainburn 09:34
Re: subselect prob in view Stephan Szabo 13:31
Re: subselect prob in view Tom Lane 13:56
Re: plpgsql - Insert from a record variable? Phil Endecott 14:05
Unrecognized node type Alvaro Sanchez-Mariscal 14:56

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