pgsql-sql - December 2005

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 13 14 15 16 17 18 19 20 21 22 23 27 28 29 30

Dec. 1, 2005

Thread Author Time
APPEND INTO? Mark Fenbers 14:23
Re: APPEND INTO? Jaime Casanova 15:32
Re: APPEND INTO? Tom Lane 15:32

Dec. 2, 2005

Thread Author Time
Sybase Connection_Property('number') equivalent in PostGre ? Emil Rachovsky 09:04
Re: Sybase Connection_Property('number') equivalent in PostGre Achilleus Mantzios 10:36
Just 1 in a series... Mark Fenbers 17:15
Re: Just 1 in a series... Tom Lane 17:20
Re: Just 1 in a series... Mark Fenbers 17:44
rename idx's with table; avoid confusing idx names? george young 18:00
Re: rename idx's with table; avoid confusing idx names? Tom Lane 22:33

Dec. 3, 2005

Thread Author Time
Re: Quote_literal() James M Doherty 13:57
question using 'between' in a sql query Theodore Petrosky 17:54
Re: question using 'between' in a sql query Michael Fuhr 18:15

Dec. 4, 2005

Thread Author Time
SQL Statement Help needed 📎 Michael Avila 12:31
Re: SQL Statement Help needed Andreas Kretschmer 13:36
Re: question using 'between' in a sql query Theodore Petrosky 16:28
How to get a count() where column < ''? Joost Kraaijeveld 21:12
Re: How to get a count() where column < ''? Stephan Szabo 21:33
Re: How to get a count() where column < ''? Joost Kraaijeveld 21:43
Re: How to get a count() where column < ''? Jim Johannsen 22:17
Re: How to get a count() where column < ''? Stephan Szabo 22:29
Re: How to get a count() where column < ''? Joost Kraaijeveld 22:36

Dec. 5, 2005

Thread Author Time
Re: Just 1 in a series... Patrick JACQUOT 10:43
Database query: Notification about change? Erik Sigra 18:22
Preventing or controlling runaway queries Eric E 19:02
Database with "override" tables Michael Burke 19:06
Re: Preventing or controlling runaway queries Tom Lane 19:35
Re: Preventing or controlling runaway queries Eric E 20:12
Re: Database query: Notification about change? Bruno Wolff III 20:40
Re: Preventing or controlling runaway queries Tom Lane 20:57
Re: Preventing or controlling runaway queries Eric E 21:33
Re: Database with "override" tables Lane Van Ingen 22:37
update question Matthew Peter 22:59
Re: update question Jaime Casanova 23:08
Re: update question Matthew Peter 23:41
Re: update question Matthew Peter 23:43

Dec. 6, 2005

Thread Author Time
Re: update question Jaime Casanova 00:33
Re: Database query: Notification about change? Erik Sigra 01:00
Re: Database query: Notification about change? Bruno Wolff III 03:35
Re: update question Tom Lane 05:45
need help Jenny 08:38
Re: need help Tino Wildenhain 08:54
need help (not anymore) Jenny 09:41
Re: need help Alban Hertroys 10:45
Date Interval Magdalena Komorowska 13:49
JOIN query not working as expected Mario Splivalo 14:08
Re: Database with "override" tables Michael Burke 14:55
Re: JOIN query not working as expected Tom Lane 14:58
Re: JOIN query not working as expected Mario Splivalo 15:00
Re: JOIN query not working as expected Tom Lane 15:02
Re: Database with "override" tables Lane Van Ingen 15:10
lost in system tables Emil Rachovsky 15:47
Re: lost in system tables Luca Pireddu 16:34
Re: Date Interval Bruce Momjian 16:54
Re: Date Interval Michael Fuhr 17:09
Re: [SQL] lost in system tables Tom Lane 17:12
Re: Date Interval Harald Fuchs 17:15
Re: Date Interval Magdalena Komorowska 17:46

Dec. 7, 2005

Thread Author Time
Re: [SQL] lost in system tables Emil Rachovsky 07:26
Re: [SQL] lost in system tables Emil Rachovsky 07:39
Help on function creating Alexandre Gonçalves Jacarandá 12:26
constrains problem... Jure Kodzoman 12:38
Re: Database with "override" tables Michael Burke 14:11
How to increase row deletion efficiency? Alexander Stanier 14:36
Re: How to increase row deletion efficiency? Tom Lane 15:11
Re: constrains problem... Richard Huxton 18:57
Re: Help on function creating Aaron Koning 19:36
Error from trigger Leif B. Kristensen 23:06
Re: Error from trigger Tom Lane 23:23
Re: Error from trigger Leif B. Kristensen 23:43

Dec. 8, 2005

Thread Author Time
Locale and pattern matching Hélder M. Vieira 01:37
dow question Keith Worthington 02:03
Re: dow question Michael Glaesemann 03:17
Re: dow question Keith Worthington 03:33
Re: Error from trigger Tom Lane 04:11
cannot alter column data type to "date" Noel Doydora 07:12
Re: cannot alter column data type to "date" Michael Fuhr 07:21
Re: Locale and pattern matching Peter Eisentraut 08:21
Re: Help on function creating Alexandre Gonçalves Jacarandá 11:24

Dec. 9, 2005

Thread Author Time
unsubscribe Dinesh Pandey 05:37

Dec. 10, 2005

Thread Author Time
Re: Error from trigger Leif B. Kristensen 10:07

Dec. 11, 2005

Thread Author Time
select count of distinct rows Havasvölgyi Ottó 00:53
Re: select count of distinct rows Jaime Casanova 00:57
Re: select count of distinct rows Havasvölgyi Ottó 01:07
Re: select count of distinct rows Jaime Casanova 01:12
Re: select count of distinct rows Foster, Stephen 01:12
Re: select count of distinct rows Jaime Casanova 01:16
Re: select count of distinct rows Havasvölgyi Ottó 01:17
Re: select count of distinct rows Frank Bax 01:23
Re: select count of distinct rows Havasvölgyi Ottó 01:25
Re: select count of distinct rows Foster, Stephen 01:28
Re: select count of distinct rows Havasvölgyi Ottó 01:29
Looking for information on PostgreSQL Stored Procedures Foster, Stephen 03:02
Re: Looking for information on PostgreSQL Stored Procedures Michael Fuhr 04:41
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Foster, Stephen 16:35
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Douglas McNaught 16:38
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Foster, Stephen 16:49
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Tom Lane 17:04
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Michael Fuhr 17:22
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Foster, Stephen 17:47
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Foster, Stephen 18:07
Re: [SQL] Looking for information on PostgreSQL Stored Procedures Tom Lane 18:08

Dec. 13, 2005

Thread Author Time
lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich 08:54
exporting Excel tables into PostgreSQL database with Python 📎 Jürgen Kemeter 10:55
Re: lo function changed in PostgreSQL 8.1.1 Tom Lane 15:39
DB design and foreign keys Gianluca Riccardi 18:16
Re: DB design and foreign keys John McCawley 18:31
Re: DB design and foreign keys Tom Lane 18:31
Re: DB design and foreign keys Jaime Casanova 18:32
Re: DB design and foreign keys Richard Huxton 18:59
Re: DB design and foreign keys Scott Marlowe 18:59
Re: exporting Excel tables into PostgreSQL database with Python Christian Kratzer 21:40
# of 5 minute intervals in period of time ... Marc G. Fournier 22:34
Multi-row update w. plpgsql function Daniel Hertz 23:00

Dec. 14, 2005

Thread Author Time
Re: Multi-row update w. plpgsql function Owen Jacobson 00:05
Re: Multi-row update w. plpgsql function Aaron Koning 02:04
Re: lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich 03:56
Help me do a LOOP Calin Meze 08:21
Re: Multi-row update w. plpgsql function Aarni Ruuhimäki 08:48
Re: exporting Excel tables into PostgreSQL database with Python Achilleus Mantzios 08:49
Re: Multi-row update w. plpgsql function Magnus Hagander 09:15
Re: DB design and foreign keys Gianluca Riccardi 10:24
Re: DB design and foreign keys Gianluca Riccardi 10:24
Re: DB design and foreign keys Gianluca Riccardi 10:25
Re: DB design and foreign keys Gianluca Riccardi 10:26
Re: DB design and foreign keys Gianluca Riccardi 10:27
Re: DB design and foreign keys Gianluca Riccardi 15:08
Finding out to which table a specific row belongs Jost Degenhardt 17:26
Re: Finding out to which table a specific row belongs Michael Fuhr 17:53
Defaulting a column to 'now' Ken Winter 18:10
Re: Defaulting a column to 'now' Bricklen Anderson 18:15
Re: Defaulting a column to 'now' Tom Lane 18:15
Re: Defaulting a column to 'now' Keith Worthington 18:22
Re: # of 5 minute intervals in period of time ... Bruno Wolff III 19:13

Dec. 15, 2005

Thread Author Time
Re: Multi-row update w. plpgsql function Daniel Hertz 00:46
Re: Extract date from week Neil Dugan 01:08
selective updates Gianluca Riccardi 15:06
RETURN SET OF DATA WITH CURSOR grupos 15:26
Re: selective updates Gianluca Riccardi 15:35
Re: RETURN SET OF DATA WITH CURSOR Richard Huxton 16:03
Re: RETURN SET OF DATA WITH CURSOR grupos 16:58
Re: RETURN SET OF DATA WITH CURSOR Richard Huxton 17:14
Re: Defaulting a column to 'now' Ken Winter 17:20

Dec. 16, 2005

Thread Author Time
Need SQL Help Finding Current Status of members 📎 Michael Avila 01:31
Re: Need SQL Help Finding Current Status of members Michael Fuhr 02:58
Re: RETURN SET OF DATA WITH CURSOR Patrick JACQUOT 08:59
Re: Need SQL Help Finding Current Status of members Richard Huxton 09:24
Re: Need SQL Help Finding Current Status of members Patrick JACQUOT 10:12
Re: Need SQL Help Finding Current Status of members Michael Avila 13:46
Re: Need SQL Help Finding Current Status of members Alvaro Herrera 13:57
Problem obtaining MAX values FROM TABLE Michael Farewell 15:42
Re: Help on function creating Alexandre Gonçalves Jacarandá 16:03
Commiting after certain no of rows have been deleted Smita Mahadik 19:37
Rule causes baffling error Ken Winter 21:07

Dec. 17, 2005

Thread Author Time
Re: Need SQL Help Finding Current Status of members Michael Avila 00:44
Re: Help on function creating Bruno Wolff III 21:35

Dec. 18, 2005

Thread Author Time
Re: Need SQL Help Finding Current Status of members Michael Fuhr 00:26
Re: Need SQL Help Finding Current Status of members Michael Avila 00:34
Does VACUUM reorder tables on clustered indices frank church 21:12
Re: Does VACUUM reorder tables on clustered indices Martin Marques 21:41
Re: Does VACUUM reorder tables on clustered indices Alvaro Herrera 22:01

Dec. 19, 2005

Thread Author Time
Re: Need SQL Help Finding Current Status of members Michael Fuhr 02:19
Re: Does VACUUM reorder tables on clustered indices Tom Lane 03:08
Re: Does VACUUM reorder tables on clustered indices Alvaro Herrera 04:29
Help on a complex query (avg data for day of the week) Matthew Smith 05:57
Re: Rule causes baffling error Richard Huxton 09:08
How to Force Transactions to Process Serially on A Table Lane Van Ingen 13:07
Re: Does VACUUM reorder tables on clustered indices Andrew Sullivan 13:25
Re: How to Force Transactions to Process Serially on A Table Lane Van Ingen 13:46
Re: How to Force Transactions to Process Serially on A Table Achilleus Mantzios 14:25
Re: How to Force Transactions to Process Serially on A Table Andrew Sullivan 14:28
Re: Does VACUUM reorder tables on clustered indices Tom Lane 15:19
Re: How to Force Transactions to Process Serially on A Table Achilleus Mantzios 15:22
Re: Rule causes baffling error Ken Winter 15:44
Question on indexes Emil Rachovsky 15:51
Re: Rule causes baffling error Richard Huxton 16:05
how to convert relational column to array? george young 16:06
Re: Rule causes baffling error Tom Lane 16:27
Re: Question on indexes vishal saberwal 16:29
Re: [SQL] Question on indexes Alvaro Herrera 16:31
Re: how to convert relational column to array? Michael Fuhr 16:54
Re: how to convert relational column to array? george young 17:12
Re: Rule causes baffling error Ken Winter 18:19

Dec. 20, 2005

Thread Author Time
Re: Rule causes baffling error Richard Huxton 09:15
Querying date_time for date only ? Aarni Ruuhimäki 12:59
Re: Querying date_time for date only ? Michael Burke 13:19
Re: Querying date_time for date only ? Aarni Ruuhimäki 13:33
Sub-query as function argument Michael Burke 13:42
Re: Sub-query as function argument Jaime Casanova 14:52
Re: Sub-query as function argument Michael Burke 15:04
Re: Querying date_time for date only ? Tom Lane 15:05
Re: Sub-query as function argument Tom Lane 15:07
Re: Does VACUUM reorder tables on clustered indices Jim C. Nasby 21:41
Re: Performance of a view Tom Lane 23:31
Re: Does VACUUM reorder tables on clustered indices ipv 23:34
unsubscribe William Lai 23:53

Dec. 21, 2005

Thread Author Time
Re: Does VACUUM reorder tables on clustered indices Jim C. Nasby 00:33
Re: Help me do a LOOP Richard Huxton 09:34
Re: Commiting after certain no of rows have been deleted Richard Huxton 09:38
Re: Help on a complex query (avg data for day of the week) Richard Huxton 10:04

Browse Archives

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