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

Aug. 7, 2003

Thread Author Time
Abort Transaction DP PK (again) alexandre :: aldeia digital 17:04
Testing gateway Marc G. Fournier 17:49
Re: EXTERNAL storage and substring on long strings Scott Cain 21:15

Aug. 8, 2003

Thread Author Time
[pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 08:13
Error message with a SQL function krystoffff 14:13
Re: duplicate dates Jonathan Gardner 15:29
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 15:52
Re: converting interval to timestamp Jonathan Gardner 16:22
Re: Analyze makes queries slow... Jonathan Gardner 16:24
Re: RI_ConstraintTrigger_11264756 Jonathan Gardner 16:30
Re: Abort Transaction DP PK (again) Josh Berkus 16:37
unexpected chunk value Eric Anderson Vianet SAO 17:40
Re: Analyze makes queries slow... Stef 17:45
Re: Abort Transaction DP PK (again) alexandre :: aldeia digital 20:22
Re: Retrieving tuple data on insert Prasanth 21:01
Re: Abort Transaction DP PK (again) Josh Berkus 21:45

Aug. 9, 2003

Thread Author Time
Comparing arrays Bertrand Petit 10:12
Re: Comparing arrays Tom Lane 14:34
Re: How to check: is some key referenced from sometable Bruno Wolff III 15:08
Re: Error message with a SQL function Tom Lane 15:16
Re: Comparing arrays Joe Conway 16:01
Re: How to check: is some key referenced from sometable eVl One 21:44

Aug. 10, 2003

Thread Author Time
Re: Retrieving tuple data on insert sebmil 03:13
Re: How to check: is some key referenced from sometable Stephan Szabo 05:30
OFF-TOPIC: Richard Huxton, Please Contact Us! Josh Berkus 18:57

Aug. 11, 2003

Thread Author Time
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon 07:07
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 07:23
Re: Comparing arrays Bertrand Petit 09:37
INSERT INTO ... SELECT Silke Trissl 10:21
sub-sel/group problem Gary Stainburn 10:24
Re: sub-sel/group problem Christoph Haller 10:38
Re: sub-sel/group problem Gary Stainburn 10:38
update system table? Eric Anderson Vianet SAO 11:36
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 13:14
Re: sub-sel/group problem Stephan Szabo 13:29
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon 13:40
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet 13:44
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo 13:48
Re: sub-sel/group problem Tomasz Myrta 13:49
Query suddenly taking longer.... Kurt Overberg 16:51
Re: Query suddenly taking longer.... Tom Lane 17:45
possible? Fejes Jozsef 19:41
Re: Query suddenly taking longer.... Kurt Overberg 19:44
Re: possible? Franco Bruno Borghesi 21:37
optimisation of a code krystoffff 22:19
string function -- replace needs a clear doc Jie Liang 22:51
Re: string function -- replace needs a clear doc Stephan Szabo 23:00
Re: string function -- replace needs a clear doc Tom Lane 23:12

Aug. 12, 2003

Thread Author Time
Re: INSERT INTO ... SELECT Christopher Browne 01:57
Re: INSERT INTO ... SELECT Jonathan Gardner 16:40
Re: optimisation of a code Jonathan Gardner 16:42
Re: How to check: is some key referenced from sometable Jonathan Gardner 16:46
How to optimize this query ? krystoffff 18:21
Re: INSERT INTO ... SELECT Vernon Smith 23:06

Aug. 13, 2003

Thread Author Time
Re: How to optimize this query ? Stephan Szabo 00:52
Re: How to optimize this query ? Franco Bruno Borghesi 01:04
Re: How to optimize this query ? Stephan Szabo 01:29
How to speeed up the query performance Abdul Wahab Dahalan 03:20
Order of triggers - totally lost SZŰCS Gábor 10:11
Re: INSERT INTO ... SELECT Christoph Haller 11:40
Insert a description while creating a table luiz 11:56
Re: Insert a description while creating a table Rod Taylor 12:06
Re: Insert a description while creating a table Benoît Bournon 12:24
Re: Insert a description while creating a table BenLaKnet 12:31
Re: Insert a description while creating a table Christoph Haller 12:54
Re: Insert a description while creating a table luiz 13:05
Re: Insert a description while creating a table Reinoud van Leeuwen 13:11
Re: How to optimize this query ? krystoffff 13:20
Re: Insert a description while creating a table Christoph Haller 13:23
Re: Error message with a SQL function krystoffff 13:25
Porting from PL/SQL to PLPGSQL Jomon Skariah 13:44
Re: Order of triggers - totally lost Christoph Haller 14:22
Re: How to speeed up the query performance Christoph Haller 14:50
Re: How to speeed up the query performance Jonathan Gardner 14:50
Re: Order of triggers - totally lost Jonathan Gardner 14:54
Re: Order of triggers - totally lost SZŰCS Gábor 15:40
Re: Order of triggers - totally lost Josh Berkus 15:55
Re: Order of triggers - totally lost SZŰCS Gábor 16:10
Re: How to optimize this query ? Franco Bruno Borghesi 16:17
Re: Order of triggers - totally lost Jonathan Gardner 16:20
Changing data type must recreate all views? Yudie 16:51
Re: How to optimize this query ? Stephan Szabo 17:10
Re: INSERT INTO ... SELECT Vernon Smith 17:14
Re: Order of triggers - totally lost Josh Berkus 17:16
Re: Order of triggers - totally lost SZŰCS Gábor 17:20
Re: How to optimize this query ? ProgHome 17:58
Why table has drop, but the foreign key still there? Raymond Chui 18:14
Re: How to optimize this query ? ProgHome 18:29
Re: How to optimize this query ? Stephan Szabo 18:29
Re: How to optimize this query ? Stephan Szabo 18:39
Re: How to optimize this query ? krystoffff 18:54
Re: Porting from PL/SQL to PLPGSQL Josh Berkus 19:35
Re: Why table has drop, but the foreign key still there? Stephan Szabo 19:38
Re: Porting from PL/SQL to PLPGSQL Rod Taylor 19:50
Re: Why table has drop, but the foreign key still there? Tom Lane 19:53
Re: Why table has drop, but the foreign key still there? Rod Taylor 19:54

Aug. 14, 2003

Thread Author Time
Re: How to speeed up the query performance Abdul Wahab Dahalan 02:51
Re: How to speeed up the query performance Stephan Szabo 03:12
Timezone troubles Jesse Scott 03:20
Re: How to speeed up the query performance Abdul Wahab Dahalan 03:22
Re: How to speeed up the query performance Abdul Wahab Dahalan 03:35
Re: Timezone troubles Josh Berkus 04:12
Re: Timezone troubles Jesse Scott 04:38
Re: Timezone troubles Jesse Scott 04:59
independent sequence for each month Tomasz Myrta 06:18
Re: Porting from PL/SQL to PLPGSQL Jomon Skariah 08:19
Re: Timezone troubles Tom Lane 11:20
Re: Timezone troubles Tom Lane 11:26
Porting from PL/SQL to PLPGSQL Jomon Skariah 13:46
Re: independent sequence for each month Bruno Wolff III 14:12
Optional join Slawek Jarosz 14:40
Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck 15:02
Re: Changing data type must recreate all views? Christoph Haller 15:18
Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane 18:00
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 18:11
Re: How to optimize this query ? krystoffff 18:14
Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck 18:55
lower/upper functions and strings in searches Gregory S. Williamson 23:46

Aug. 15, 2003

Thread Author Time
Re: lower/upper functions and strings in searches Stephan Szabo 00:00
Re: lower/upper functions and strings in searches Josh Berkus 00:17
Re: Optional join Stephan Szabo 04:40
Re: Optional join Bruno Wolff III 04:57
Re: Optional join David Fetter 05:50
sequence cristi 09:32
Re: sequence Bertrand Petit 10:30
Re: sequence Dennis Björklund 10:40
Re: sequence Tom Lane 12:01
Re: About primary keys. Tim Andersen 14:38
Re: About primary keys. Tom Lane 15:57
[Newbie] migrating a stored procedure from MSSQL to postgresql Bengali 16:27
Re: How to optimize this query ? ProgHome 20:24
Re: About primary keys. Tim Andersen 21:32

Aug. 16, 2003

Thread Author Time
Re: About primary keys -- made some progress Tim Andersen 04:15
Do it exist? Hal Davison 09:38
Re: About primary keys -- made some progress Tom Lane 12:36
Re: Optional join Ian Barwick 16:56

Aug. 17, 2003

Thread Author Time
Re: Do it exist? Rod Taylor 02:47
Expression transformation curiosity Richard Huxton 10:32
Re: Expression transformation curiosity Tom Lane 15:23
Re: Expression transformation curiosity Alexander M. Pravking 15:39
Re: Expression transformation curiosity Richard Huxton 17:01

Aug. 18, 2003

Thread Author Time
Reverse pattern match. Moonstruck 07:05
Re: Reverse pattern match. Rod Taylor 23:05
Re: Reverse pattern match. Josh Berkus 23:11

Aug. 19, 2003

Thread Author Time
Inheritance or no inheritance, there is a question Vernon Smith 03:59
Re: Inheritance or no inheritance, there is a question Josh Berkus 04:36
Re: Changing data type must recreate all views? Peter Eisentraut 07:53
Configuring Problem on Solaris............ Chidananda 08:32
postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli 08:43
Migration from db2 to postgres' 📎 shyamperi 10:52
link toward pgsql-sql is missing on the left menu at http://archives.postgresql.org/ Richard NAGY 12:26
Re: Migration from db2 to postgres' Tim Andersen 12:43
Query problem Rado Petrik 13:02
Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane 13:26
Re: postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli 13:41
Re: Query problem Richard Huxton 14:21
Re: Query problem Bruno Wolff III 15:50

Aug. 20, 2003

Thread Author Time
Re: Inheritance or no inheritance, there is a question Josh Berkus 00:12
Re: Reverse pattern match. Moonstruck 06:42
Re: Wicked screensaver zakkr 06:57
Porting from PL/SQL to PLPGSQL Jomon Skariah 09:45
Re: Inheritance or no inheritance, there is a question David Fetter 15:11
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 16:27
Re: "SELECT IN" Still Broken in 7.4b Mike Winter 16:45
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 17:09
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 17:10
Before/After Trigger User Switching Aasmund Midttun Godal 17:12
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 17:41
Re: "SELECT IN" Still Broken in 7.4b Mike Winter 18:51
Re: "SELECT IN" Still Broken in 7.4b Joe Conway 19:24
Table conversion query... George McQuade 19:31
Re: Before/After Trigger User Switching Aasmund Midttun Godal 19:34
Re: Before/After Trigger User Switching Tom Lane 20:12
Re: Table conversion query... Joe Conway 20:19
Re: "SELECT IN" Still Broken in 7.4b Tom Lane 20:32
Re: Before/After Trigger User Switching Aasmund Midttun Godal 20:33
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 20:41
Re: Before/After Trigger User Switching Tom Lane 20:53
problem with automatic altering of groups Matthias Nagl 21:09
Re: Porting from PL/SQL to PLPGSQL Roberto Mello 21:12
Re: Configuring Problem on Solaris............ LAIN Lucas TECHTEL 21:16
problem with automatic altering of groups Matthias Nagl 21:18
Re: Configuring Problem on Solaris............ Peter Eisentraut 21:18
Re: Table conversion query... George McQuade 21:28
Re: problem with automatic altering of groups Josh Berkus 21:32
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 21:55
Re: [Newbie] migrating a stored procedure from MSSQL to postgresql Richard Hall 22:28
Re: Table conversion query... Joe Conway 23:57

Aug. 21, 2003

Thread Author Time
URGENT : free result (libpq++ API) Anagha Joshi 05:57
Re: URGENT : free result (libpq++ API) Stephan Szabo 06:11
Re: "SELECT IN" Still Broken in 7.4b Oleg Bartunov 07:38
Re: "SELECT IN" Still Broken in 7.4b Dani Oderbolz 10:05
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 17:28
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 20:42
Re: [SQL] "SELECT IN" Still Broken in 7.4b Stephan Szabo 21:07
Re: [SQL] "SELECT IN" Still Broken in 7.4b Manfred Koizar 21:18
Re: [SQL] "SELECT IN" Still Broken in 7.4b Josh Berkus 21:19
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 21:46
Re: [SQL] "SELECT IN" Still Broken in 7.4b Joe Conway 22:01
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 22:17

Browse Archives

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