pgsql-sql - March 2005

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

March 1, 2005

Thread Author Time
Re: AutoCommit and DDL Don Drake 00:40
Re: table constraints Andrew - Supernews 01:01
Re: AutoCommit and DDL Andrew - Supernews 01:09
Re: table constraints Casey T. Deccio 01:25
Re: Advanced SELECT Kai Hessing 09:36
Re: Postgres performance mauro 10:52
Re: table constraints Greg Patnude 16:56

March 2, 2005

Thread Author Time
crosstab Theo Galanakis 04:30
Re: crosstab Josh Berkus 04:47
Re: psql encoding problem Ragnar Hafstað 07:57
Re: Postgres performance Michael Fuhr 08:17
Re: Postgres performance Richard Huxton 08:38
Re: Postgres performance Mauro Bertoli 09:33
Re: Postgres performance Richard Huxton 10:28
Re: Postgres performance Mauro Bertoli 11:24
Multiples schemas lucas 11:30
Re: Postgres performance Richard Huxton 12:06
Re: psql encoding problem Joel Fradkin 13:51
Re: Multiples schemas Peter Eisentraut 14:24
Re: Postgres performance Scott Marlowe 15:00
Re: table constraints Casey T. Deccio 16:14
definative way to place secs from epoc into timestamp column Bret Hughes 16:25
Re: psql encoding problem T E Schmitz 16:42
Re: definative way to place secs from epoc into timestamp column Tom Lane 19:52
Re: definative way to place secs from epoc into timestamp Bret Hughes 20:07
Re: definative way to place secs from epoc into timestamp Tom Lane 20:26
Re: Postgres performance PFC 21:45
Re: Postgres performance Scott Marlowe 22:06
Re: Postgres performance Andrew Sullivan 23:09
Re: Postgres performance Ian Barwick 23:35

March 3, 2005

Thread Author Time
Building a database from a flat file Casey T. Deccio 00:15
truncating table permissions Lynwood Stewart 02:30
Re: definative way to place secs from epoc into timestamp Bret Hughes 05:42
Re: definative way to place secs from epoc into timestamp Tom Lane 06:25
Re: definative way to place secs from epoc into timestamp Michael Glaesemann 06:41
how to monitor the archiving process? Smit 07:19
Re: definative way to place secs from epoc into timestamp Bret Hughes 07:21
Re: definative way to place secs from epoc into timestamp Bret Hughes 07:27
how to speed up these queries ? Dracula 007 11:05
Re: Multiples schemas Markus Schaber 12:17
Re: how to speed up these queries ? Sean Davis 13:08
Re: Building a database from a flat file Sean Davis 13:23
Re: how to speed up these queries ? Sean Davis 13:42
Problem with SQL_ASCII Kai Hessing 14:23
Re: [WW Spam: medium] Building a database from a flat file RobertD.Stewart 14:39
Re: Performance of Views Christoph Haller 15:04
Re: Building a database from a flat file Markus Schaber 15:28
Re: Postgres performance Christopher Browne 17:39
Re: Building a database from a flat file Casey T. Deccio 18:29
Re: Building a database from a flat file Casey T. Deccio 18:37
Re: Building a database from a flat file Markus Schaber 18:44
Re: Building a database from a flat file Bricklen Anderson 18:47
Re: Building a database from a flat file Sean Davis 19:30
Re: Building a database from a flat file Markus Schaber 20:21
Re: definative way to place secs from epoc into timestamp Andrew - Supernews 20:58
Simple delete takes hours Thomas Mueller 21:44

March 4, 2005

Thread Author Time
Re: definative way to place secs from epoc into timestamp Bret Hughes 05:47
Re: definative way to place secs from epoc into timestamp Andrew - Supernews 07:15
Re: definative way to place secs from epoc into timestamp Michael Glaesemann 07:35
Re: definative way to place secs from epoc into timestamp Joel Fradkin 15:01
Re: definative way to place secs from epoc into timestamp Tom Lane 15:14
Re: definative way to place secs from epoc into timestamp Ken Johanson 15:20
Re: definative way to place secs from epoc into timestamp Ken Johanson 15:29
date - date returns integer? Andrew Hammond 20:59
Re: date - date returns integer? Bruno Wolff III 21:54
Re: Simple delete takes hours Stephan Szabo 22:27
Re: Postgres performance PFC 23:20
Re: Simple delete takes hours PFC 23:24
Re: Simple delete takes hours Lynwood Stewart 23:35

March 5, 2005

Thread Author Time
Re: definative way to place secs from epoc into timestamp Andrew - Supernews 00:45
Re: truncating table permissions Keith Worthington 03:35
Re: definative way to place secs from epoc into timestamp Bret Hughes 03:39
Re: date - date returns integer? Tom Lane 04:36
Re: truncating table permissions Tom Lane 05:02
Re: Simple delete takes hours Thomas Mueller 14:00
Re: Postgres performance Mauro Bertoli 16:31
Re: Postgresql FK to MS SQL triggers Josh Berkus 22:04
Re: Postgres performance PFC 22:53

March 6, 2005

Thread Author Time
Links between rows in a table Stefan Weiss 04:42
Re: Postgres performance Mauro Bertoli 14:42
count array in plpgsql bandeng 16:49
count array in postgresql bandeng 16:54
Re: Links between rows in a table Bruno Wolff III 17:42
Re: Links between rows in a table Stefan Weiss 18:27
Re: count array in postgresql Michael Fuhr 19:10
Re: Links between rows in a table PFC 19:26
Re: Postgres performance PFC 19:29
Re: Building a database from a flat file Andrew - Supernews 19:58
Re: Links between rows in a table Stefan Weiss 20:07

March 7, 2005

Thread Author Time
Re: count array in postgresql bandeng 02:09
Re: count array in postgresql Sean Davis 02:21
Re: count array in postgresql Michael Fuhr 03:29
Re: Postgres performance Mauro Bertoli 08:29
Postgres schema comparison. Stef 09:33
Re: [SQL] Postgres schema comparison. Markus Schaber 12:01
simple update from select ?? Gary Stainburn 12:28
Re: Postgres schema comparison. John DeSoi 12:39
Re: [SQL] Postgres schema comparison. Stef 12:54
Maintaining production DBs, making one schema look like the other KÖPFERL Robert 13:03
Re: [SQL] Postgres schema comparison. Richard_D_Levine 13:03
Re: [SQL] Postgres schema comparison. 📎 Markus Schaber 13:06
Re: [SQL] Postgres schema comparison. Stef 13:40
Re: [SQL] Postgres schema comparison. Tom Lane 14:30
Re: simple update from select ?? Gary Stainburn 14:44
Re: Postgres schema comparison. Stef 15:09
Re: [SQL] Postgres schema comparison. Stef 15:22
Re: [SQL] Postgres schema comparison. Stef 15:31
Re: Postgres schema comparison. John DeSoi 15:32
Re: Postgres schema comparison. Goulet, Dick 15:33
Re: [SOLVED] Postgres schema comparison. Stef 16:08
Re: [ADMIN] Postgres schema comparison. 📎 Jim Buttafuoco 16:14
Re: Links between rows in a table Bruno Wolff III 16:15
SQL query help? John McGough 16:22
Lambda expressions in SQL KÖPFERL Robert 18:20
Re: Links between rows in a table PFC 18:41
drop view even with dependencies? Henry Ortega 21:38

March 8, 2005

Thread Author Time
Re: drop view even with dependencies? Michael Fuhr 01:17
Re: SQL query help? Keith Worthington 04:36
Update PostgreSQL from MS SQL trigger Igor Kryltsov 04:47
Re: SQL query help? Michael Fuhr 07:06
group by before and after date Sim Zacks 07:29
Re: [SQL] Postgres schema comparison. Stef 08:00
Re: group by before and after date Sim Zacks 08:09
Re: Postgres schema comparison. Matteo Beccati 08:59
Query issue/8.0.1/Serendipity Larry Rosenman 11:48
plpgsql & date-time functions Fatih Cerit 12:14
Re: Query issue/8.0.1/Serendipity Richard Huxton 12:17
Re: Query issue/8.0.1/Serendipity Larry Rosenman 12:17
Re: Query issue/8.0.1/Serendipity Michael Glaesemann 12:21
Re: Query issue/8.0.1/Serendipity Larry Rosenman 12:28
Re: Query issue/8.0.1/Serendipity Larry Rosenman 12:29
Re: Query issue/8.0.1/Serendipity Michael Glaesemann 12:35
Re: Query issue/8.0.1/Serendipity Larry Rosenman 12:36
How to cast VARCHAR to BYTEA and vice-versa? Moran.Michael 15:31
Re: Query issue/8.0.1/Serendipity Tom Lane 15:37
Re: Query issue/8.0.1/Serendipity Larry Rosenman 15:41
Re: Query issue/8.0.1/Serendipity Ian Barwick 16:55
Re: Query issue/8.0.1/Serendipity Larry Rosenman 16:58
Re: Update PostgreSQL from MS SQL trigger Igor Kryltsov 22:44
Newbie wonder... Bernard Grosperrin 23:25

March 9, 2005

Thread Author Time
datestyle setting Kenneth Gonsalves 06:05
Re: datestyle setting Tom Lane 06:27
Re: datestyle setting Kenneth Gonsalves 07:21
Re: datestyle setting Richard Huxton 08:10
interval +variable Fatih Cerit 08:58
Re: interval +variable Michael Fuhr 09:17
Re: datestyle setting Kenneth Gonsalves 09:47
Re: datestyle setting Richard Huxton 09:57
Re: [SQL] Postgres schema comparison. KÖPFERL Robert 10:39
order by question Gary Stainburn 12:41
Re: order by question Richard Huxton 13:06
Table like a field lucas 13:46
Re: order by question Achilleus Mantzios 13:48
Re: order by question Gary Stainburn 14:06
Re: interval +variable Bruno Wolff III 14:19
Re: Table like a field Richard Huxton 14:19
Re: order by question Bruno Wolff III 14:26
Re: order by question Greg Stark 15:50
Re: [SQL] [SOLVED] Postgres schema comparison. 📎 Stef 17:19

March 10, 2005

Thread Author Time
Re: interval +variable AL ELK 09:30
best way to auto-update a field when row is updated Henry Ortega 20:09
Re: best way to auto-update a field when row is updated Larry Rosenman 20:21
Re: best way to auto-update a field when row is updated Scott Marlowe 20:35

March 11, 2005

Thread Author Time
pl/pgsql problem with return types Juris Zeltins 10:54
more execution time AL ELK 11:54
Re: pl/pgsql problem with return types John DeSoi 12:46
Re: pl/pgsql problem with return types Juris Zeltins 12:50
Re: [GENERAL] more execution time Richard Huxton 13:05
Conver bool to text Edmund Bacon 16:57
Re: Conver bool to text Marco Manfredini 22:12

March 12, 2005

Thread Author Time
Parameterized views proposition Tambet Matiisen 11:40
Re: Parameterized views proposition PFC 12:07
Re: Parameterized views proposition Tambet Matiisen 14:13
Re: Parameterized views proposition Bruno Wolff III 16:34
Re: Parameterized views proposition Tambet Matiisen 18:00
Re: Parameterized views proposition Andrew - Supernews 19:18

March 13, 2005

Thread Author Time
finding schema of table that called a trigger Jeff Hoffmann 21:32

March 14, 2005

Thread Author Time
Re: plpgsql & date-time functions Stephan Szabo 02:33
Re: Newbie wonder... Sean Davis 02:50
outputting dates Kenneth Gonsalves 03:47
lower and unicode pginfo 06:01
sql: "LIKE" problem Her Goo 06:16
Re: sql: "LIKE" problem Tom Lane 07:32
Re: lower and unicode 📎 Miroslav Šulc 08:15
Re: sql: "LIKE" problem Richard Huxton 08:16
Re: finding schema of table that called a trigger Richard Huxton 08:20
Re: How to cast VARCHAR to BYTEA and vice-versa? Ragnar Hafstað 08:46
Re: group by before and after date PFC 08:58
Re: Newbie wonder... PFC 09:02
Re: lower and unicode pginfo 09:40
Re: How to cast VARCHAR to BYTEA and vice-versa? Christoph Haller 10:32
Re: lower and unicode 📎 Miroslav Šulc 10:43
How does the planner treat a table function. KÖPFERL Robert 11:26
Re: lower and unicode pginfo 11:50
Re: lower and unicode 📎 Miroslav Šulc 12:57
Re: Newbie wonder... Rod Taylor 13:56
Re: How to cast VARCHAR to BYTEA and vice-versa? Lance Peterson 17:31
Inserting values in arrays Robert.Farrugia 17:53
Generic Function lucas 18:15

March 15, 2005

Thread Author Time
postgresql 8.01, plpgsql Timothy Smith 01:35

Browse Archives

Prev | Next