pgsql-sql - October 2006

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 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 27 28 29 30 31

Oct. 2, 2006

Thread Author Time
Re: regexp_replace usage Michael Fuhr 03:56
Re: regexp_replace usage chester c young 15:15
Doubt with Joins Ezequias Rodrigues da Rocha 15:41
SEQUENCES Rodrigo Sakai 16:39
Re: SEQUENCES Andrew Sullivan 16:49
Re: SEQUENCES Thomas Kellerer 16:51
Time interval sums A. R. Van Hook 20:58
Re: Time interval sums Tom Lane 21:29

Oct. 3, 2006

Thread Author Time
Re: How to FindNearest Bruno Wolff III 00:20
Assigning a timestamp without timezone to a timestamp with timezone chrisj 03:15
LOG: logger shutting down Bryce Nesbitt 04:06
Re: LOG: logger shutting down Tom Lane 04:32
i have table Penchalaiah P. 10:47
Re: i have table A. Kretschmer 10:59
Re: i have table Achilleas Mantzios 11:00
Re: How to FindNearest Alexander Ilyin 11:43
Re: i have table Daryl Richter 11:49
Re: Assigning a timestamp without timezone to a timestamp with timezone Andrew Sullivan 13:56
Re: Assigning a timestamp without timezone to a timestamp chrisj 14:26
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 14:51
Update 3 columns w/ 1 function calc 3 values? paallen 14:55
Re: SEQUENCES Bruno Wolff III 14:59
Re: Update 3 columns w/ 1 function calc 3 values? William Leite Araújo 15:19
Re: Assigning a timestamp without timezone to a timestamp chrisj 15:45
Re: How to FindNearest Bruno Wolff III 17:11
Re: Update 3 columns w/ 1 function calc 3 values? Bruno Wolff III 17:19
Updating from table with multiple possibilities Worky Workerson 17:32
Fw: How to FindNearest paallen 17:35
timestamps over the web - suggestions chester c young 21:44
formatting intervals with to_char Graham Davis 23:03

Oct. 4, 2006

Thread Author Time
Re: timestamps over the web - suggestions Aaron Bono 01:15
Re: timestamps over the web - suggestions ljb 01:35
Re: Fw: How to FindNearest Bruno Wolff III 04:11
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 09:07
Re: i have table Markus Schaber 09:22
How to overwrite a table [only data]? Ezequias Rodrigues da Rocha 11:40
Re: How to overwrite a table [only data]? Harald Armin Massa 11:50
Re: Assigning a timestamp without timezone to a timestamp christopher wood 13:35
Re: i have table Erik Jones 14:23
Re: i have table Aaron Bono 14:54
Re: [SQL] How to overwrite a table [only data]? Aaron Bono 14:55
Re: i have table Erik Jones 15:37
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 15:44
Re: i have table Aaron Bono 16:20
Re: Assigning a timestamp without timezone to a timestamp christopher wood 16:35
Re: Update 3 columns w/ 1 function calc 3 values? Markus Schaber 16:36
Re: i have table Daryl Richter 16:37
Re: [SQL] How to overwrite a table [only data]? Markus Schaber 16:49
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 16:52
Re: i have table Aaron Bono 18:02
Re: formatting intervals with to_char Graham Davis 18:03
Re: Assigning a timestamp without timezone to a timestamp Hector Villarreal 18:04
Re: i have table Scott Marlowe 20:11

Oct. 5, 2006

Thread Author Time
Re: i have table operationsengineer1 01:23
psql hangs during load of pg_dumpall file James Baxendale 04:33
Re: formatting intervals with to_char Aaron Bono 04:39
Re: i have table Achilleas Mantzios 07:32
Re: i have table Tom Lane 13:31
Re: i have table Achilleas Mantzios 15:15
Re: i have table Andrew Sullivan 15:29
timestamp subtraction (was Re: formatting intervals with to_char) Tom Lane 16:50
age() vs. timestamp substraction Martin Marques 18:27
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 18:31
Re: age() vs. timestamp substraction Tom Lane 18:37
Re: age() vs. timestamp substraction Martin Marques 18:43
On Rollback my sequency does not back the initial value Ezequias Rodrigues da Rocha 18:50
Postgresql quey planner William Leite Araújo 19:02
Re: On Rollback my sequency does not back the initial value A. Kretschmer 19:16
Re: Postgresql quey planner Tom Lane 19:20
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:01
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:06
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 20:31
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:45
Re: Assigning a timestamp without timezone to a timestamp Hector Villarreal 20:53

Oct. 6, 2006

Thread Author Time
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Michael Glaesemann 01:32
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Tom Lane 01:36
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Jim Nasby 02:40
Re: age() vs. timestamp substraction Jean-Paul Argudo 09:35
Re: age() vs. timestamp substraction Stephan Szabo 13:56
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals Graham Davis 15:05
SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join James Robinson 15:31
Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join Tom Lane 16:25
Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join James Robinson 16:30
Too much time to delete 19000 rows Ezequias Rodrigues da Rocha 18:10
Re: Too much time to delete 19000 rows Andrew Sullivan 18:26
Re: Too much time to delete 19000 rows Tom Lane 18:27
Re: timestamps over the web - suggestions Bruno Wolff III 18:27

Oct. 8, 2006

Thread Author Time
PG 8.2beta reordering working for this case? 📎 Kyle Bateman 01:00
Re: PG 8.2beta reordering working for this case? Tom Lane 17:49
optimal insert Dirk Jagdmann 21:04

Oct. 9, 2006

Thread Author Time
Re: optimal insert Bruno Wolff III 04:09
Re: PG 8.2beta reordering working for this case? 📎 Kyle Bateman 05:27
Re: PG 8.2beta reordering working for this case? Tom Lane 14:15
Re: i have table Aaron Bono 16:01
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Aaron Bono 19:57
deleting rows in specific order Daniel Drotos 20:14
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Jim C. Nasby 21:54
Re: deleting rows in specific order Frank Bax 22:00
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Josh Berkus 22:09

Oct. 10, 2006

Thread Author Time
storing access rights in a postgres database tv 13:38
Re: i have table Andrew Sullivan 18:30
Temp tables and functions mark.dingee 19:21
Re: optimal insert Aaron Bono 20:45
Re: optimal insert George Pavlov 21:04
Re: optimal insert Dirk Jagdmann 21:12
Re: optimal insert Dirk Jagdmann 21:15
Re: storing access rights in a postgres database Dirk Jagdmann 21:57

Oct. 11, 2006

Thread Author Time
Re: Temp tables and functions Jim C. Nasby 02:11
Re: Temp tables and functions Mark R. Dingee 11:02
Re: optimal insert Markus Schaber 12:31
Re: deleting rows in specific order Markus Schaber 12:48
Re: deleting rows in specific order Daniel Drotos 19:31

Oct. 12, 2006

Thread Author Time
slow view Stuart 01:18
Re: slow view Stuart McGraw 04:15
Is this a bug? Deleting a column deletes the constraint. Bryce Nesbitt 05:11
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 05:25
Re: Is this a bug? Deleting a column deletes the constraint. Joe 09:39
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 14:39
Re: Is this a bug? Deleting a column deletes the constraint. Chris Browne 14:56
Re: Is this a bug? Deleting a column deletes the constraint. Florian Weimer 16:19
spliting a row to make several rows Gerardo Herzig 22:18
Re: spliting a row to make several rows Bricklen Anderson 22:42
Re: spliting a row to make several rows Gerardo Herzig 23:00

Oct. 13, 2006

Thread Author Time
could not connect to server ivan marchesini 06:52
Re: could not connect to server A. Kretschmer 07:27
Re: could not connect to server ivan marchesini 09:01
Re: could not connect to server A. Kretschmer 09:18
Re: deleting rows in specific order Markus Schaber 11:48
Re: could not connect to server Tom Lane 14:07
Re: storing access rights in a postgres database Aaron Bono 21:16

Oct. 14, 2006

Thread Author Time
Foreign key reference counting strategy? Joost Kraaijeveld 12:25
Re: Foreign key reference counting strategy? Markus Schaber 13:52
Re: Assigning a timestamp without timezone to a timestamp chrisj 21:42
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 23:26
Re: Foreign key reference counting strategy? Michael Fuhr 23:48
Re: Foreign key reference counting strategy? Tom Lane 23:58

Oct. 15, 2006

Thread Author Time
Re: Foreign key reference counting strategy? Michael Fuhr 00:11
Re: Foreign key reference counting strategy? Tom Lane 00:20
Re: Foreign key reference counting strategy? Michael Fuhr 01:07
Re: Foreign key reference counting strategy? Tom Lane 02:10
conversion of numeric field from MSSQL to postgres Kenneth Gonsalves 12:31
migrating numeric to serial from MSSQL to postgres Kenneth Gonsalves 13:05
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 13:49
Re: migrating numeric to serial from MSSQL to postgres Terry Fielder 13:54
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 15:23
Temp tables, reports in Postgresql (and other RDBMS) ow 16:08
Re: Temp tables, reports in Postgresql (and other RDBMS) Tom Lane 16:54
Re: Temp tables, reports in Postgresql (and other RDBMS) ow 18:10

Oct. 16, 2006

Thread Author Time
Re: Assigning a timestamp without timezone to a timestamp chrisj 02:32
Recursive pl/pgsql function ... Marc G. Fournier 02:39
Re: Recursive pl/pgsql function ... Tom Lane 03:27
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 03:31
Re: Recursive pl/pgsql function ... Marc G. Fournier 06:16
Re: Recursive pl/pgsql function ... Markus Schaber 09:20
hi i want help on levels Penchalaiah P. 14:47
Re: get_next_billing_date() ... Marc G. Fournier 17:25
Re: deleting rows in specific order Bruno Wolff III 17:51

Oct. 17, 2006

Thread Author Time
Re: Assigning a timestamp without timezone to a timestamp chrisj 03:27
How to split a table? Felix Zhang 07:39
Any documatation about porting from Oracle to PostgreSQL Felix Zhang 07:50
Re: How to split a table? Andreas Kretschmer 08:34
Re: Any documatation about porting from Oracle to PostgreSQL Andreas Kretschmer 08:36
Re: Any documatation about porting from Oracle to PostgreSQL Thomas Kellerer 08:44
Can we convert from Postgres to Oracle !!??? Sandeep Kumar Jakkaraju 08:51
Re: [SQL] How to split a table? Gregory S. Williamson 08:53
Re: [NOVICE] How to split a table? Felix Zhang 09:07
Re: [GENERAL] How to split a table? Achilleas Mantzios 09:09
Re: [SQL] [GENERAL] How to split a table? A. Kretschmer 09:12
Re: [SQL] [GENERAL] How to split a table? Gregory S. Williamson 09:19
Re: [NOVICE] How to split a table? Christoph Frick 09:26
Re: Any documatation about porting from Oracle to PostgreSQL A. Kretschmer 09:36
Re: Any documatation about porting from Oracle to PostgreSQL Shane Ambler 10:25
Re: [SQL] [GENERAL] How to split a table? Jorge Godoy 10:51
Re: [NOVICE] How to split a table? Obe, Regina 10:54
Fwd: Re: [GENERAL] How to split a table? Achilleas Mantzios 11:08
Re: Can we convert from Postgres to Oracle !!??? Berend Tober 12:38
Re: [SQL]Any documatation about porting from Oracle to PostgreSQL Lewis Cunningham 13:20
Re: Can we convert from Postgres to Oracle !!??? Ron Johnson 13:22
Re: Can we convert from Postgres to Oracle !!??? Harald Armin Massa 13:22
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 13:34
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:42

Oct. 18, 2006

Thread Author Time
Bug? Indira Muthuswamy 13:23
Re: Bug? Andrew Dunstan 13:31
plpgsql record as parameter ??? Andy 13:49
Re: [HACKERS] Bug? Jim C. Nasby 18:43
Re: hi i want help on levels Jim C. Nasby 23:18

Oct. 19, 2006

Thread Author Time
Re: Any documatation about porting from Oracle to PostgreSQL Robert Treat 01:57
Re: [HACKERS] Bug? Indira Muthuswamy 06:58
Grouping by day, limiting amounts 📎 Mezei Zoltán 11:51
Re: Grouping by day, limiting amounts A. Kretschmer 12:30
Re: Grouping by day, limiting amounts A. Kretschmer 14:17
Re: Grouping by day, limiting amounts Woody Woodring 14:45
Re: [HACKERS] Bug? Jim C. Nasby 16:50
Re: Grouping by day, limiting amounts Jim C. Nasby 16:55

Oct. 20, 2006

Thread Author Time
PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL Rares Vernica 03:14

Oct. 21, 2006

Thread Author Time
Re: conversion of numeric field from MSSQL to postgres Daniel CAUNE 03:55
Re: conversion of numeric field from MSSQL to postgres Richard Broersma Jr 04:01
Re: PostgreSQL 8.1.5 Documentation - Chapter 32. Extending SQL Michael Fuhr 04:37
Re: conversion of numeric field from MSSQL to postgres Tom Lane 04:42
Re: conversion of numeric field from MSSQL to postgres Richard Broersma Jr 05:10

Browse Archives

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