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

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
Re: cross-table reference	Bruno Wolff III	13:23
Re: ENUM like data type	Rod Taylor	13:28
Re: ORDER records based on parameters in IN clause	Russell Simpkins	14:22
Re: ORDER records based on parameters in IN clause	Michael Fuhr	14:33
Re: ORDER records based on parameters in IN clause	Scott Marlowe	15:07
Re: ENUM like data type	Peter Eisentraut	21:20
Re: ENUM like data type	Tom Lane	22:55
Error saving image to PostgresSQL 8.x database	Fred Cunningham	23:13

June 30, 2005

Thread	Author	Time
Foreign key pg_dump issue and serial column type	Vsevolod (Simon) Ilyushchenko	00:25
Re: Foreign key pg_dump issue and serial column type	Tom Lane	01:15
Re: Error saving image to PostgresSQL 8.x database	Josh Berkus	03:56
Re: ORDER records based on parameters in IN clause	M.D.G. Lange	07:34
Re: ORDER records based on parameters in IN clause	Dawid Kuroczko	07:51
Re: ENUM like data type	KÖPFERL Robert	08:01
SQL Query question	Nick Stone	09:27
Re: ORDER records based on parameters in IN clause	Greg Sabino Mullane	10:39
Re: ENUM like data type	Peter Eisentraut	11:13
Re: SQL Query question	Peter Eisentraut	11:18
Re: SQL Query question	Richard Huxton	11:22
Re: ORDER records based on parameters in IN clause	Daryl Richter	11:58
Re: SQL Query question	Nick Stone	12:22
Updatable view	M.D.G. Lange	13:50

July 1, 2005

Thread	Author	Time
UNIT-tests and SQL	KÖPFERL Robert	08:52
SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle.	Vadivel Subramaniam	09:04
'show full processlist' in postgres?	Erik Wasser	13:58
Some help please	Nick Stone	16:12
Re: 'show full processlist' in postgres?	Jim Buttafuoco	16:24
Re: 'show full processlist' in postgres?	Erik Wasser	17:13
Re: Some help please	Josh Berkus	17:30
Re: Some help please	Nick Stone	17:42
Re: 'show full processlist' in postgres?	Tom Lane	19:42
Re: [despammed] Re: 'show full processlist' in postgres?	Andreas Kretschmer	20:19

July 4, 2005

Thread	Author	Time
select values from interval	Josep Sanmartí	12:00
Re: Help on Procedure running external function	Zac	12:47
Re: Help on Procedure running external function	KÖPFERL Robert	15:20
Re: Help on Procedure running external function	Zac	15:27
Re: Help on Procedure running external function	Bruno Wolff III	17:00
Re: select values from interval	Bruno Wolff III	17:03
Help on Procedure running external function	Din Adrian	21:14
Re: Help on Procedure running external function	Din Adrian	23:10

July 5, 2005

Thread	Author	Time
Recursive function	Gnanavel Shanmugam	05:05
Re: Recursive function	Gnanavel Shanmugam	05:32
Re: Recursive function	Nick Stone	06:27
Create connection with Oracle database from Postgres plpgsql function	Dinesh Pandey	09:40
Re: Create connection with Oracle database from Postgres plpgsql function	Michael Glaesemann	10:02
Re: Help on Procedure running external function	Zac	11:47
Re: Help on Procedure running external function	Bruno Wolff III	12:39
Re: Create connection with Oracle database from Postgres plpgsql	Bricklen Anderson	14:26
Re: Help on Procedure running external function	Din Adrian	19:10
Re: Help on Procedure running external function	Din Adrian	22:06
Re: Help on Procedure running external function	Din Adrian	22:52

Browse Archives

Prev | Next