Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-sql - June 2004

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

2004-06-01

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)

2004-06-02

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)

2004-06-03

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)

2004-06-04

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)

2004-06-06

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)

2004-06-07

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)

2004-06-08

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)

2004-06-09

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)

2004-06-10

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)

2004-06-11

(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)

2004-06-14

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)

2004-06-15

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)

2004-06-16

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)

2004-06-17

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)

2004-06-18

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)

2004-06-19

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)

2004-06-20

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)

2004-06-21

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)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group