pgsql-sql since 2006-02-19 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

Feb. 19, 2006

Thread Author Time
Re: Need help: Find dirty rows, Update, Delete SQL Janning Vygen 10:44
Re: Given 02-01-2006 to 02-28-2006, output all days. Henry Ortega 18:47
Re: Given 02-01-2006 to 02-28-2006, output all days. Stephan Szabo 18:57
Re: Given 02-01-2006 to 02-28-2006, output all days. Michael Fuhr 19:07

Feb. 20, 2006

Thread Author Time
Re: ORDER BY with LTREE Michael Fuhr 07:41
Re: Interval subtracting Milorad Poluga 08:39
Re: SELECT on a to-be-determined table Patrick JACQUOT 11:02
Re: Need help: Find dirty rows, Update, Delete SQL Patrick JACQUOT 11:24
Re: ORDER BY CASE ... Bruno Wolff III 17:33
Re: Given 02-01-2006 to 02-28-2006, output all days. Pedro B. 20:30
Re: Given 02-01-2006 to 02-28-2006, output all days. Mark R. Dingee Pedro 20:39
Re: ... more than one count with left join Pedro B. 20:56

Feb. 21, 2006

Thread Author Time
Re: ORDER BY with LTREE Michael Fuhr 06:31
Re: ORDER BY with LTREE Axel Straschil 07:03
Avoid querying a specific field - how? Stefan Schwarzer 11:55
Re: Avoid querying a specific field - how? Ibrahim Tekin 15:32
Re: Avoid querying a specific field - how? Achilleus Mantzios 17:06

Feb. 22, 2006

Thread Author Time
restircting rows padmanabha konkodi 09:06
Re: passing array(java) to postgre sql function Markus Schaber 09:17
Re: restircting rows Richard Huxton 09:18
Re: restircting rows A. Kretschmer 09:19
Re: restircting rows Michael Glaesemann 09:23
Feature, my misconception or bug?? Achilleus Mantzios 12:04
Re: Feature, my misconception or bug?? Peter Eisentraut 12:47
Re: Feature, my misconception or bug?? Markus Schaber 12:55
Re: Feature, my misconception or bug?? Markus Schaber 12:56
pg reserved words Irina Gadassik 15:27
Re: Feature, my misconception or bug?? Achilleus Mantzios 16:31
Update in all tables Judith Altamirano Figueroa 17:59
'locking' the SELECTs based on indices... Mario Splivalo 18:02
Update in all tables Judith 18:08
Re: Update in all tables Janning Vygen 18:33
Re: 'locking' the SELECTs based on indices... Tom Lane 18:58
Re: Update in all tables Scott Marlowe 19:12
Re: Update in all tables Andrew Sullivan 21:13
Re: Update in all tables Scott Marlowe 21:16
Re: Update in all tables Owen Jacobson 21:25

Feb. 23, 2006

Thread Author Time
Re: Feature, my misconception or bug?? Achilleus Mantzios 09:03
Re: 'locking' the SELECTs based on indices... Mario Splivalo 10:13
Re: 'locking' the SELECTs based on indices... Mario Splivalo 11:02
Re: 'locking' the SELECTs based on indices... PFC 16:30
Re: 'locking' the SELECTs based on indices... PFC 16:35
Sum If Daniel Hernandez 17:46
Re: Sum If Jim Buttafuoco 18:09
Re: Sum If Daniel Hernandez 19:03
Re: 'locking' the SELECTs based on indices... Mario Splivalo 20:07
Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 21:44
Re: Question about index scan vs seq scan when using count() Andrew Sullivan 22:12
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:25
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:35
Re: Question about index scan vs seq scan when using count() Andrew Sullivan 22:47
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:55
Re: Question about index scan vs seq scan when using count() Owen Jacobson 23:08

Feb. 24, 2006

Thread Author Time
how to add primary key to existing table with multiple primary keys Daniel Joo 01:45
CREATE TABLE AS and tablespaces Markus Schaber 10:45
dbLink Query Richard C 11:29
"Installing" dbLink Richard C 11:48
Re: "Installing" dbLink A. Kretschmer 12:43
Re: After Trigger assignment to NEW Tom Lane 16:06
After Trigger assignment to NEW Achilleus Mantzios 16:44
Re: After Trigger assignment to NEW Alvaro Herrera 17:16
Re: After Trigger assignment to NEW Tom Lane 17:37
Missing fields on Query result. Daniel Hernandez 18:08
Re: Missing fields on Query result. Daniel Hernandez 18:10
Re: After Trigger assignment to NEW Owen Jacobson 18:58
Re: After Trigger assignment to NEW Achilleus Mantzios 19:47
Re: After Trigger assignment to NEW Achilleus Mantzios 19:51
Can't connect to the db Judith 22:17
Re: Can't connect to the db Andrew Sullivan 22:21
Obtaining client IP address Alexis Paul Bertolini 23:16
Re: Obtaining client IP address Michael Fuhr 23:34

Feb. 25, 2006

Thread Author Time
Re: CREATE TABLE AS and tablespaces Bruce Momjian 04:51
Relation 0 does not exist Yasuhiro Furuse 07:06
Re: After Trigger assignment to NEW Achilleus Mantzios 07:40
Re: Obtaining client IP address Alexis Paul Bertolini 09:26
Re: "Installing" dbLink Richard C 10:42
Index to support LIKE '%suffix' queries Florian Weimer 14:17
Re: After Trigger assignment to NEW Stephan Szabo 14:40
Re: Relation 0 does not exist Alvaro Herrera 15:24
Re: Index to support LIKE '%suffix' queries Tom Lane 17:22
Re: Index to support LIKE '%suffix' queries Florian Weimer 17:52
Re: Index to support LIKE '%suffix' queries Alvaro Herrera 18:13

Feb. 26, 2006

Thread Author Time
Re: Relation 0 does not exist Yasuhiro Furuse 23:26

Feb. 27, 2006

Thread Author Time
Re: Slow update SQL Bungsuputra Linan 02:42
Disabling triggers/constraints pg<8.1 Bath, David 02:44
Dump/restore comments only? Bath, David 02:56
Problem with query on history table Andreas Joseph Krogh 07:19
Re: Dump/restore comments only? Ragnar 09:04

Feb. 28, 2006

Thread Author Time
grant select,... over schema chester c young 16:35
Re: grant select,... over schema Michael James 16:43
Re: grant select,... over schema chester c young 17:10
plsql / time statement Daniel Caune 23:49

March 1, 2006

Thread Author Time
Re: plsql / time statement Steve Crawford 00:06
Re: Slow update SQL Ken Hill 01:26
Re: how to add primary key to existing table with multiple Stephan Szabo 02:53
Re: pg reserved words Michael Glaesemann 03:05
regarding grant option AKHILESH GUPTA 04:20
Re: regarding grant option Michael Fuhr 05:19
Re: Index to support LIKE '%suffix' queries Florian Weimer 07:19
Re: Slow update SQL Mauricio Fernandez A. 10:17
Re: how to add primary key to existing table with multiple primary keys Mauricio Fernandez A. 10:17
Re: Index to support LIKE '%suffix' queries A. Kretschmer 11:33
Help with trigger that updates a row prior to a potentially aborted deletion? Simon Kinsella 13:30
Re: [SQL] regarding grant option Alvaro Herrera 13:49
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Simon Kinsella 14:19
Re: [SQL] regarding grant option AKHILESH GUPTA 14:28
Re: Help with trigger that updates a row prior to a potentially Stephan Szabo 14:30
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Simon Kinsella 14:43
Re: [SQL] regarding grant option Alvaro Herrera 15:00
Re: [SQL] Interval subtracting Mark Dilger 17:05
Change date format through an environmental variable? Mark Fenbers 17:32
Replication - state of the art? Bryce Nesbitt 17:51
Re: grant select,... over schema Bruno Wolff III 17:59
Re: [SQL] Interval subtracting Bruce Momjian 17:59
Re: [SQL] Interval subtracting Mark Dilger 18:06
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Andrew Sullivan 18:23
Re: [SQL] Interval subtracting Jim C. Nasby 18:24
Re: Replication - state of the art? Andrew Sullivan 18:28
Re: [SQL] Interval subtracting 📎 Mark Dilger 18:39
Re: Change date format through an environmental variable? Andrew Sullivan 18:47
Re: Change date format through an environmental variable? Mark Fenbers 19:20
Re: Change date format through an environmental variable? Andrew Sullivan 19:26
Re: Replication - state of the art? Bryce Nesbitt 19:28
Re: Change date format through an environmental variable? Michael Fuhr 19:42
Re: Replication - state of the art? Andrew Sullivan 19:49
Re: Replication - state of the art? Scott Marlowe 20:09
Re: [SQL] Interval subtracting Bruce Momjian 20:13
Re: [SQL] Interval subtracting Bruce Momjian 20:18
Re: [SQL] Interval subtracting Scott Marlowe 20:21
Re: [SQL] Interval subtracting Bruce Momjian 20:27
Re: [SQL] Interval subtracting Tom Lane 20:28
Re: [SQL] Interval subtracting Hannu Krosing 20:28
Re: [SQL] Interval subtracting Stephan Szabo 20:32
Re: [SQL] Interval subtracting Bruce Momjian 20:33
Re: [SQL] Interval subtracting Bruce Momjian 20:33
Re: [SQL] Interval subtracting Tom Lane 20:35
Re: [SQL] Interval subtracting Scott Marlowe 20:36
Re: [SQL] Interval subtracting Mark Dilger 20:39
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Simon Kinsella 20:41
Re: [SQL] Interval subtracting Mark Dilger 20:46
Re: [SQL] Interval subtracting Tom Lane 20:55
Re: [SQL] Interval subtracting Mark Dilger 21:04
Re: [SQL] Interval subtracting Tom Lane 21:11
Re: [SQL] Interval subtracting Mark Dilger 21:21
Re: [SQL] Interval subtracting Bruce Momjian 21:45
Re: [SQL] Interval subtracting Mark Dilger 21:52
Re: [SQL] regarding grant option Jim C. Nasby 22:12
Re: Replication - state of the art? Jim C. Nasby 22:15
Re: Problem with query on history table Jim C. Nasby 22:19
Re: [SQL] Interval subtracting 📎 Mark Dilger 22:30
Re: [SQL] Interval subtracting Tom Lane 22:45
Re: [SQL] Interval subtracting Mark Dilger 22:54
Re: [SQL] Interval subtracting Bruce Momjian 23:02
Re: [SQL] Interval subtracting Mark Dilger 23:07
Re: [SQL] Interval subtracting Tom Lane 23:07
Re: [SQL] Interval subtracting Mark Dilger 23:10
Re: [SQL] Interval subtracting Bruce Momjian 23:11
Re: [SQL] Interval subtracting Tom Lane 23:17
Re: [SQL] Interval subtracting Tom Lane 23:20
Re: Replication - state of the art? Andrew Sullivan 23:23
Re: [SQL] Interval subtracting Tom Lane 23:23
Re: [SQL] Interval subtracting Bruce Momjian 23:26
Re: [SQL] Interval subtracting Mark Dilger 23:43
Re: Problem with query on history table Andreas Joseph Krogh 23:47
Re: [SQL] Interval subtracting Mark Dilger 23:49
Re: [SQL] Interval subtracting Tom Lane 23:58

March 2, 2006

Thread Author Time
Re: [SQL] Interval subtracting Mark Dilger 00:02
Re: [SQL] Interval subtracting Tom Lane 00:37
Re: [SQL] Interval subtracting Mark Dilger 01:18
Re: Change date format through an environmental variable? Tom Lane 06:16
Re: [SQL] Interval subtracting Hannu Krosing 06:45
Re: [SQL] Interval subtracting Tino Wildenhain 07:05
Re: Change date format through an environmental variable? Michael Fuhr 07:33
Re: Change date format through an environmental variable? Michael Fuhr 07:42
Re: Change date format through an environmental variable? Peter Eisentraut 08:46
dump with lo Maciej Piekielniak 11:41
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Andrew Sullivan 12:19
Without OIDs Emil Rachovsky 13:14
FW: sql copy does not work Aniko.Badzong 14:26
Re: [SQL] Interval subtracting Tom Lane 14:49
Re: dump with lo Tom Lane 15:21
Re: Change date format through an environmental variable? george young 15:33
Re: [SQL] Without OIDs Michael Fuhr 15:57
Re: [SQL] Interval subtracting Scott Marlowe 16:13
Question about Sql SELECT and optimizer Chaz. 16:19
Re: dump with lo Maciej Piekielniak 16:59
Re: Question about Sql SELECT and optimizer Michael Fuhr 17:04
Re: [SQL] Interval subtracting Hannu Krosing 17:50
Re: [SQL] Interval subtracting Mark Dilger 18:06
Re: [SQL] Interval subtracting Martijn van Oosterhout 18:43
Re: [SQL] Interval subtracting Tom Lane 19:10
Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause? Davidson, Robert 22:33
Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause? Michael Fuhr 22:49

March 3, 2006

Thread Author Time
Re: Help with trigger that updates a row prior to a potentially aborted deletion? Simon Kinsella 00:19
How to check date-interval constraints Andreas 03:28
Re: How to check date-interval constraints Michael Fuhr 05:13
Re: How to check date-interval constraints Michael Glaesemann 05:25
Sequential scan where Index scan expected. Bryce Nesbitt 07:27
Sequential scan where Index scan expected (update) Bryce Nesbitt 07:28
Re: Sequential scan where Index scan expected (update) Gregory S. Williamson 07:37

Browse Archives

Prev | Next