pgsql-sql since 2004-03-22 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

March 22, 2004

Thread Author Time
special integrity constraints Erik Thiele 09:20
Re: special integrity constraints Achilleus Mantzios 10:13
Re: special integrity constraints Erik Thiele 10:26
Re: special integrity constraints Bruno Wolff III 11:26
Re: inverse of "day of year" Martin Marques 11:32
Re: special integrity constraints Achilleus Mantzios 11:40
Re: inverse of "day of year" Bruno Wolff III 12:50
Re: special integrity constraints Erik Thiele 13:10
Re: inverse of "day of year" Martin Marques 13:14
Re: special integrity constraints Stephan Szabo 14:21
Re: special integrity constraints Bruno Wolff III 15:12
Re: inverse of "day of year" Bruno Wolff III 15:18
Re: inverse of "day of year" Dana Hudes 15:56
Re: special integrity constraints Erik Thiele 16:21
Re: special integrity constraints Erik Thiele 16:25
Re: special integrity constraints Stephan Szabo 16:34

March 23, 2004

Thread Author Time
Re: [SQL] special integrity constraints Bruno Wolff III 00:34
function definition documentation Gregory S. Williamson 02:16
Sorting an aggregated column David Witham 03:26
Re: Sorting an aggregated column Tom Lane 05:17
Re: Sorting an aggregated column David Witham 07:17
Re: special integrity constraints Achilleus Mantzios 07:26
Re: function definition documentation Richard Huxton 08:08
Newbie Query question Marcel Loose 09:56
Re: inverse of "day of year" Martin Marques 14:04
fine grained trigger time specification... Erik Thiele 14:19
Re: Sorting an aggregated column Tom Lane 14:54
Re: fine grained trigger time specification... Bruno Wolff III 16:17
Re: fine grained trigger time specification... Erik Thiele 16:56
Re: fine grained trigger time specification... Stephan Szabo 17:22
Re: could not create shared memory segment: Invalid argument xvx 18:30
Re: Database reporting tool Bill 18:51
Re: [GENERAL] PHP or JSP? That is the question. Guy Fraser 19:05
SQL Query beyaNet Consultancy 20:02
Re: SQL Query Bruno Wolff III 20:46
move forward 0 from foo; Chester Kustarz 21:13
Re: move forward 0 from foo; Tom Lane 22:37

March 24, 2004

Thread Author Time
Re: function definition documentation Gregory S. Williamson 00:04
Invalid Unicode Character Sequence found Bulatovic Natasa 12:24

March 25, 2004

Thread Author Time
order of results Gregor Rot 13:23
Using Bounding Box as a where predicate Okeh, Sam 19:21

March 26, 2004

Thread Author Time
how to turn off autocommit in psql Kemin Zhou 01:25
Re: how to turn off autocommit in psql Paul Thomas 08:59
date_part stored procs Tsoloane Moahloli 14:19
Re: Newbie Query question Rod Taylor 14:49
autocommit Kemin Zhou 19:31
Re: Invalid Unicode Character Sequence found Tom Lane 21:43
Re: order of results Bruno Wolff III 21:53
Re: date_part stored procs Tom Lane 23:03

March 27, 2004

Thread Author Time
Re: autocommit Tom Lane 03:23
Re: Invalid Unicode Character Sequence found Markus Bertheau 10:02

March 28, 2004

Thread Author Time
Re: Slow sub-selects, max and count(*) Greg Stark 06:31

March 29, 2004

Thread Author Time
Re: date_part stored procs Tsoloane Moahloli 07:30
Re: Invalid Unicode Character Sequence found Bulatovic Natasa 07:33
Question on pgsql trigger Jon Poulton 17:12
Re: Slow sub-selects, max and count(*) Josh Berkus 21:47

March 30, 2004

Thread Author Time
Entered data appears TWICE in table!!? Ron M. 19:29
plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 22:08

March 31, 2004

Thread Author Time
SQL Spec Compliance Questions Josh Berkus 04:50
Re: [SQL] SQL Spec Compliance Questions Tom Lane 05:18
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 06:14
Re: plpgsql vs. SQL in stored procedures Christopher Browne 08:31
Timestamp manipulation Stephen Quinney 10:41
Re: plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 11:07
Re: plpgsql vs. SQL in stored procedures Richard Huxton 12:06
Is it normal that functions are so much faster than inline queries Olivier Hubaut 12:28
Re: Is it normal that functions are so much faster than inline queries Tom Lane 15:33
Simple insert not returning Kyle 18:06
left join on a view takes significantly more time. Manuel Sugawara 18:55
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 22:41
Re: left join on a view takes significantly more time. Josh Berkus 23:49

April 1, 2004

Thread Author Time
Re: Is it normal that functions are so much faster than inline queries Olivier Hubaut 07:07
Re: DB question - Merging data from one table to another. malia, sean 15:27
Getting the ranks of results from a query abhi 16:05
Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:20
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:36
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:48
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:51
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:57

April 2, 2004

Thread Author Time
Re: SQL Spec Compliance Questions Joe Conway 07:03
Re: SQL Spec Compliance Questions Josh Berkus 16:38
Re: SQL Spec Compliance Questions Joe Conway 16:48
Re: SQL Spec Compliance Questions Josh Berkus 16:53
Re: [SQL] SQL Spec Compliance Questions Tom Lane 17:47

April 3, 2004

Thread Author Time
Re: order of results Gregor Rot 15:08
Re: SQL Spec Compliance Questions Peter Eisentraut 23:24
Re: [SQL] SQL Spec Compliance Questions Peter Eisentraut 23:26

April 5, 2004

Thread Author Time
oracle varray functionality? Postgres User 15:45
Function To Log Changes Gavin 17:01
Re: Function To Log Changes Josh Berkus 17:18
Re: Function To Log Changes Tom Lane 17:39
group by not returning sorted rows Bret Hughes 21:55
Re: Entered data appears TWICE in table!!? Jeff Eckermann 22:33
Re: group by not returning sorted rows Tom Lane 22:34
Re: Question on pgsql trigger Jeff Eckermann 22:34
Re: group by not returning sorted rows Stephan Szabo 22:54
Re: DB question - Merging data from one table to another. scott.marlowe 22:55

April 6, 2004

Thread Author Time
Re: Rename Schema or Script DDL only a schema Olivier Hubaut 08:17
Rename Schema or Script DDL only a schema kumar 09:02
could not devise a query plan SZŰCS Gábor 13:12
Re: Entered data appears TWICE in table!!? Jeff Eckermann 14:27
partial unique constraint Robert Treat 14:29
Re: could not devise a query plan Tom Lane 15:00
Re: partial unique constraint Stephan Szabo 15:05
Re: partial unique constraint ries 15:05
Re: partial unique constraint Tom Lane 15:17
Re: partial unique constraint Rod Taylor 15:17
Re: partial unique constraint Achilleus Mantzios 15:18
Re: partial unique constraint Paul Thomas 15:26
Re: partial unique constraint Robert Treat 16:38
Re: group by not returning sorted rows Bret Hughes 16:51
distinct values without seq scan Bret Hughes 17:06
SQL Standatd Ricardo Vaz Mannrich 18:21
Re: SQL Standatd Bruce Momjian 19:01
Re: could not devise a query plan Tom Lane 19:05
Re: Function To Log Changes elein 19:06
Re: partial unique constraint Richard Huxton 19:54
Help with COPY command Tony Reina 20:31

April 7, 2004

Thread Author Time
Re: Getting the ranks of results from a query Bruno Wolff III 04:29
Re: order of results Bruno Wolff III 05:33
Re: Unknown Exception ([email protected]) ?? 07:38
Re: Function To Log Changes Erik Thiele 09:42
Counting rows from two tables in one query Stefan Weiss 10:06
setting a non-standard date format for the duration of a session Cris Carampa 12:47
Re: SQL Standatd Ricardo Vaz Mannrich 13:44
Re: SQL Standatd Bruce Momjian 14:26
Re: distinct values without seq scan Josh Berkus 15:43
varray? table of varchar? Postgres User 16:15
notify and leaks? Theodore Petrosky 16:30
Crypt() encryption Christina Zhang 17:01
Re: notify and leaks? Tom Lane 18:27
Row count after SELECT INTO? Alexander M. Pravking 19:04
Re: Help with COPY command Tony Reina 19:32
Re: SQL Standatd Martin Marques 21:16
Re: SQL Standatd Bruce Momjian 21:59
Re: SQL Standatd Joe Conway 22:39

April 8, 2004

Thread Author Time
Re: SQL Standatd Bruce Momjian 00:25
pgsql multi-database queries yek ching 07:52
Encoding and result string length kumar 09:32
Re: Encoding and result string length Richard Huxton 11:00
SQL challenge--top 10 for each key value? Jeff Boes 19:55
Re: SQL challenge--top 10 for each key value? Greg Stark 23:33

April 9, 2004

Thread Author Time
Re: SQL challenge--top 10 for each key value? Rod Taylor 03:31
Re: SQL challenge--top 10 for each key value? Tom Lane 06:11
Re: could not devise a query plan SZŰCS Gábor 12:23
hi sir urgent..required a Query 📎 Rajeev Chaudhary, Noida 12:28
Utility of recursive queries? James Robinson 14:33
Re: SQL challenge--top 10 for each key value? Josh Berkus 16:06
Re: Utility of recursive queries? Josh Berkus 16:07
Re: Utility of recursive queries? Tom Lane 16:35
Re: SQL challenge--top 10 for each key value? Greg Stark 22:43

April 10, 2004

Thread Author Time
Re: Crypt() encryption Bruce Momjian 01:06
Re: pgsql multi-database queries scott.marlowe 01:23
Re: Counting rows from two tables in one query Greg Sabino Mullane 01:28
Re: SQL challenge--top 10 for each key value? Rod Taylor 01:29
Re: SQL challenge--top 10 for each key value? Greg Sabino Mullane 14:35
Re: Counting rows from two tables in one query Bruno Wolff III 15:09
Re: hi sir urgent..required a Query Josh Berkus 15:16
Re: setting a non-standard date format for the duration of a session Josh Berkus 15:19
Re: SQL challenge--top 10 for each key value? Josh Berkus 15:51
begin update ... syntax error Kemin Zhou 21:32
Re: begin update ... syntax error Gregory S. Williamson 21:51
Re: begin update ... syntax error Adrian Klaver 22:07
Re: SQL challenge--top 10 for each key value? Troels Arvin 22:13
Re: SQL challenge--top 10 for each key value? Troels Arvin 22:17
Re: begin update ... syntax error Yasir Malik 22:19
Re: SQL challenge--top 10 for each key value? elein 23:46

April 11, 2004

Thread Author Time
Re: SQL challenge--top 10 for each key value? elein 01:54
Re: SQL challenge--top 10 for each key value? Greg Stark 04:38
cursors and for loops? Dennis 04:59
trigger/for key help Bret Hughes 05:43
Re: trigger/for key help Stephan Szabo 15:17
Re: cursors and for loops? Tom Lane 16:00
Re: SQL challenge--top 10 for each key value? elein 18:20
Re: cursors and for loops? Dennis 18:46
Re: trigger/for key help Bret Hughes 19:19
Re: trigger/for key help Tom Lane 22:00
Re: trigger/for key help Bret Hughes 22:58

April 12, 2004

Thread Author Time
Re: trigger/for key help Tom Lane 02:27
Re: trigger/for key help Bret Hughes 07:18
Re: Function for numbering rows? CoL 22:21

April 13, 2004

Thread Author Time
Re: trigger/for key help Greg Stark 06:20
Re: cursors and for loops? Richard Huxton 08:31
relation X does not exist Laura Scott 12:49
Re: trigger/for key help Tom Lane 13:25
Formatting Functions and Group By Terry Brick 16:13
Re: Formatting Functions and Group By Bruno Wolff III 16:45
Re: Formatting Functions and Group By Tom Lane 17:33
Re: trigger/for key help Greg Stark 17:36
Re: Formatting Functions and Group By Terry Brick 17:49
Re: SQL challenge--top 10 for each key value? Jeff Boes 18:34
Re: trigger/for key help Tom Lane 18:35
function returning array Dennis 22:41

April 14, 2004

Thread Author Time
Re: function returning array Tom Lane 03:30
Re: function returning array Joe Conway 04:10
Database triggers Charity M 13:57
Re: Help with COPY command Christoph Haller 15:42
Re: Help with COPY command Tony and Bryn Reina 15:54
full join...using and version of pgsql Tina Messmann 17:05
Re: full join...using and version of pgsql scott.marlowe 20:39

Browse Archives

Prev | Next