pgsql-sql since 2005-06-14 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

June 14, 2005

Thread Author Time
Re: getting details about integrity constraint violation Greg Sabino Mullane 03:39
Spam Re: read it immediately 📎 alessio 05:38
Re: getting details about integrity constraint violation Markus Bertheau 05:46
WHY transaction waits for another transaction? Vilinski Vladimir 11:12
foreign key on pg_shadow M.D.G. Lange 11:34
Re: SELECT very slow PFC 12:26
Re: foreign key on pg_shadow Tom Lane 13:37
Set Membership operator -- test group membership Sophie Yang 19:08
Re: Set Membership operator -- test group membership Igor Katrayev 19:27

June 15, 2005

Thread Author Time
Re: getting details about integrity constraint violation Greg Sabino Mullane 02:06
update syntax Praveen Raja 11:39
Converting varchar to bool KÖPFERL Robert 12:14
Re: update syntax Bruno Prévost 12:22
Re: update syntax Praveen Raja 12:35
Re: update syntax Bruno Prévost 12:49
Re: Converting varchar to bool Bruno Wolff III 14:31
Re: update syntax Bruno Wolff III 14:34
Re: SELECT very slow Thomas Kellerer 18:05
Re: SELECT very slow PFC 20:04
Re: SELECT very slow Thomas Kellerer 22:08
Dynamic PL/pgSQL Ruediger Herrmann 22:10
cursor "<unnamed portal 1>" does not exist Vsevolod (Simon) Ilyushchenko 22:45

June 16, 2005

Thread Author Time
funny update, say update 1, updated 1 added 2nd. Neil Dugan 03:38
PostgreSQL and Delphi 6 Postgres Admin 03:49
SELECT with sum on groups ORDERING by the subtotals grupos 03:56
Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam 04:25
Re: PostgreSQL and Delphi 6 Postgres Admin 12:09
Function does not return, but gives error.. M.D.G. Lange 12:26
Re: Function does not return, but gives error.. Gnanavel Shanmugam 12:34
Re: Function does not return, but gives error.. M.D.G. Lange 12:39
Re: Function does not return, but gives error.. M.D.G. Lange 12:43
Re: Function does not return, but gives error.. Michael Fuhr 12:47
Re: [SQL] PostgreSQL and Delphi 6 grupos 12:54
Re: SELECT with sum on groups ORDERING by the subtotals grupos 13:07
Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam 13:28
Re: [SQL] PostgreSQL and Delphi 6 grupos 13:29
Re: SELECT very slow Scott Marlowe 14:00
Re: funny update, say update 1, updated 1 added 2nd. Jim Buttafuoco 14:05
Re: SELECT very slow Thomas Kellerer 14:45
Re: cursor "<unnamed portal 1>" does not exist Andrew Sullivan 14:54
Re: [SQL] PostgreSQL and Delphi 6 grupos 15:04
Re: SELECT with sum on groups ORDERING by the subtotals grupos 15:10
Re: SELECT very slow PFC 15:29
Re: SELECT very slow Thomas Kellerer 15:33
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 17:11
Re: [SQL] Returning a Cross Tab record set from a function Marc Wrubleski 17:16
Re: SELECT with sum on groups ORDERING by the subtotals Greg Sabino Mullane 19:01
UPDATEABLE VIEWS ... Examples? Marc G. Fournier 21:05
Re: PostgreSQL and Delphi 6 Din Adrian 22:31
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 23:11
Re: [SQL] PostgreSQL and Delphi 6 Din Adrian 23:38

June 17, 2005

Thread Author Time
Re: UPDATEABLE VIEWS ... Examples? elein 01:04
Re: UPDATEABLE VIEWS ... Examples? Dmitri Bichko 01:33
Re: UPDATEABLE VIEWS ... Examples? Michael Fuhr 02:07
Still getting autoreplies from list member Michael Fuhr 03:16
Re: Still getting autoreplies from list member Dmitri Bichko 03:30
Re: Still getting autoreplies from list member Kenneth Gonsalves 03:53
Putting an INDEX on a boolean field? Marc G. Fournier 04:14
Re: Putting an INDEX on a boolean field? David Dick 04:35
Re: Putting an INDEX on a boolean field? Tom Lane 04:41
Re: Putting an INDEX on a boolean field? Marc G. Fournier 05:04
Re: Putting an INDEX on a boolean field? Jaime Casanova 05:42
substr or char_length problem Fatih Cerit 10:01
Re: [despammed] substr or char_length problem Andreas Kretschmer 10:25
Re: Putting an INDEX on a boolean field? Erik Aronesty 10:40
Re: substr or char_length problem Michael Fuhr 12:06
how can i UPDATE without dead rows 📎 csepinek 13:08
Re: UPDATEABLE VIEWS ... Examples? Bricklen Anderson 14:54
Re: how can i UPDATE without dead rows Richard Huxton 16:09
Re: SELECT with sum on groups ORDERING by the subtotals grupos 17:15

June 18, 2005

Thread Author Time
partial index on non default tablespace syntax Rajesh Kumar Mallah 16:54
Re: partial index on non default tablespace syntax Michael Fuhr 17:27
Re: partial index on non default tablespace syntax Tom Lane 17:40

June 19, 2005

Thread Author Time
Re: partial index on non default tablespace syntax Rajesh Kumar Mallah 06:21
Re: [SQL] Set Membership operator -- test group membership Oleg Bartunov 08:48
Re: Dynamic PL/pgSQL PFC 10:36
Re: Looking for info on 8.1 features, and some examples Michael Fuhr 14:27
Re: WHY transaction waits for another transaction? Tom Lane 15:05
Re: WHY transaction waits for another transaction? Michael Fuhr 15:58
Re: WHY transaction waits for another transaction? Michael Fuhr 16:22
Re: Putting an INDEX on a boolean field? Tom Lane 18:46

June 20, 2005

Thread Author Time
accessing database without a persistent connection mohammad izwan ibrahim 03:11
Re: accessing database without a persistent connection Michael Fuhr 04:37
Re: AYUDA CON LA INSTALACION DEL POSTGRESQL Nahum Castro 04:37
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:16
Re: UPDATEABLE VIEWS ... Examples? Jaime Casanova 07:24
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:27
Re: UPDATEABLE VIEWS ... Examples? Michael Glaesemann 07:37
Re: UPDATEABLE VIEWS ... Examples? David Pradier 07:56
FW: help with serial Luca Rasconi 09:33
info Luca Rasconi 09:45
Re: [despammed] info Andreas Kretschmer 09:57
Re: info Richard Huxton 10:08
Re: FW: help with serial Richard Huxton 10:10
Re: info Theodore Petrosky 12:29
SQL repr of bytea val Markus Bertheau ☭ 13:47
Array in plpgsql with composite type grupos 16:31
Re: UPDATEABLE VIEWS ... Examples? Din Adrian 20:49
Re: Array in plpgsql with composite type Michael Fuhr 23:36

June 21, 2005

Thread Author Time
Re: SQL repr of bytea val Michael Fuhr 00:12
SELECT INTO returning more than one row Zac 09:54
customising serial type Kenneth Gonsalves 10:01
Re: customising serial type Krasimir Dimitrov 10:07
Re: customising serial type Michael Glaesemann 10:23
ENUM like data type MRB 15:20
Re: customising serial type Stefan Becker 16:34

June 22, 2005

Thread Author Time
Re: scroll cursor bug or me? Sim Zacks 08:22
cross-table reference Mukesh Ghatiya 09:26
Alias to a type Veikko Mäkinen 11:27
Re: Alias to a type Achilleus Mantzios 11:42
Re: Alias to a type Sean Davis 12:04
Re: Alias to a type Richard Huxton 12:07
Re: Alias to a type Achilleus Mantzios 12:14
Re: Alias to a type Bruno Wolff III 12:18
Re: Alias to a type Veikko Mäkinen 13:14
Re: Alias to a type KÖPFERL Robert 14:42
after delete trigger behavior Russell Simpkins 16:06
Re: after delete trigger behavior Stephan Szabo 16:31
Re: after delete trigger behavior Tom Lane 19:12
Re: after delete trigger behavior Stephan Szabo 19:27
Re: after delete trigger behavior Russell Simpkins 19:27
encoding question Joel Fradkin 19:36
Re: after delete trigger behavior Tom Lane 19:46
Re: after delete trigger behavior Russell Simpkins 20:09

June 23, 2005

Thread Author Time
Unique primary index? orange_crush_068 12:43
Re: after delete trigger behavior Russell Simpkins 13:15
Help with query, stuck :( bumby 17:03
optimizer, view, union Markus Bertheau 17:31
Grouping Too Closely Thomas F. O'Connell 19:16
Re: optimizer, view, union Tom Lane 19:28
empty view, replace view, column type change? Markus Bertheau 20:03
Re: Grouping Too Closely Russell Simpkins 20:03
Re: empty view, replace view, column type change? Rod Taylor 20:19
Re: empty view, replace view, column type change? Markus Bertheau 20:21
Re: empty view, replace view, column type change? Rod Taylor 20:26
Re: empty view, replace view, column type change? Markus Bertheau 20:27
Re: empty view, replace view, column type change? Tom Lane 22:21

June 24, 2005

Thread Author Time
Re: empty view, replace view, column type change? Bruce Momjian 04:32
Re: empty view, replace view, column type change? Tom Lane 14:32
Converting TBL->View complaining about indexes KÖPFERL Robert 15:49
Re: Converting TBL->View complaining about indexes Michael Fuhr 17:44
Default index space? Dmitri Bichko 23:01

June 25, 2005

Thread Author Time
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] Bruce Momjian 01:50
Re: people who buy A, also buy C, D, E Greg Sabino Mullane 03:35
Re: Grouping Too Closely Greg Sabino Mullane 04:22
Re: Grouping Too Closely Thomas F. O'Connell 05:32
Re: Grouping Too Closely Greg Sabino Mullane 06:40
Re: people who buy A, also buy C, D, E Jan Wieck 14:00

June 26, 2005

Thread Author Time
using 'zoneinfo' to manipulate dates ... Marc G. Fournier 03:24
Re: using 'zoneinfo' to manipulate dates ... Alvaro Herrera 06:15
multiple PK with a non UNIQUE field davide 14:58
Re: multiple PK with a non UNIQUE field Mathieu Arnold 15:14
Re: multiple PK with a non UNIQUE field Jim Buttafuoco 15:19
Re: people who buy A, also buy C, D, E PFC 16:25
assorted problems with intarray and other GiST contribs. PFC 16:48
Re: assorted problems with intarray and other GiST contribs. Oleg Bartunov 17:41
Re: assorted problems with intarray and other GiST contribs. PFC 17:56
Re: assorted problems with intarray and other GiST contribs. Michael Fuhr 18:25
Re: multiple PK with a non UNIQUE field davide 20:20

June 27, 2005

Thread Author Time
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] Joe Conway 04:08
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] Bruce Momjian 09:39
SELECT * FROM foo OFFSET -1 LIMIT 1 Markus Bertheau ☭ 15:34
ORDER records based on parameters in IN clause Riya Verghese 16:15
How can I simply substatue a value in a query? Roy Souther 17:16
Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Martín Marqués 17:17
pg_attribute.attlen -1 for varchar e pbchar fields jimmy.olsen 17:27
Re: How can I simply substatue a value in a query? Sean Davis 17:31
Re: How can I simply substatue a value in a query? Jim Buttafuoco 17:35
Re: How can I simply substatue a value in a query? Bryan Encina 17:45
Re: How can I simply substatue a value in a query? davide 18:18
Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Markus Bertheau 18:41
Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Greg Stark 19:35
Re: pg_attribute.attlen -1 for varchar e pbchar fields Michael Fuhr 20:35

June 28, 2005

Thread Author Time
Re: ORDER records based on parameters in IN clause Michael Fuhr 04:57
Re: ENUM like data type Kenneth Gonsalves 06:41
Re: Unique primary index? M.D.G. Lange 07:50
ERROR: "TZ"/"tz" not supported Sergey Levchenko 10:20
Re: ENUM like data type Mike Rylander 11:22
ERROR: "TZ"/"tz" not supported Sergey Levchenko 11:39
Re: ENUM like data type Bruno Wolff III 12:37
Re: cross-table reference Bruno Wolff III 12:47
Re: Unique primary index? Bruno Wolff III 12:53
Re: ERROR: "TZ"/"tz" not supported Tom Lane 14:31
Re: ENUM like data type PFC 16:58
Re: Unique primary index? PFC 17:01
Re: Unique primary index? Scott Marlowe 17:47
Re: ENUM like data type Martín Marqués 18:22
Re: ENUM like data type Scott Marlowe 18:46
Re: ENUM like data type Nick Johnson 19:55
Re: people who buy A, also buy C, D, E Greg Sabino Mullane 23:53

June 29, 2005

Thread Author Time
Re: ORDER records based on parameters in IN clause Greg Sabino Mullane 00:13
Re: ENUM like data type Dawid Kuroczko 07:09
Re: ORDER records based on parameters in IN clause Russell Simpkins 11:19
Re: ORDER records based on parameters in IN clause Dawid Kuroczko 11:44
Re: ORDER records based on parameters in IN clause Michael Fuhr 11:57
Re: ORDER records based on parameters in IN clause Zac 12:09
Re: ORDER records based on parameters in IN clause Zac 12:12
Re: ENUM like data type KÖPFERL Robert 12:40
Insert rule and default values for PK KÖPFERL Robert 12:53
Re: ENUM like data type Martín Marqués 13:21

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