pgsql-sql since 2007-04-04 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

April 4, 2007

Thread Author Time
Re: [SQL] exception handling in postgres plpgsql Tom Lane 00:24
Re: plpgsql function question A. Kretschmer 05:01
Moving a simple function to pl/pgsql (Novice question) Paul Lambert 06:19
Generating dates prior to generate_series Roger Tannous 12:00
Re: plpgsql function question John DeSoi 12:19
CPU statistics ezequias 12:36
Setting high performance on huge server ezequias 12:49
Re: Setting high performance on huge server Claus Guttesen 12:55
Re: Moving a simple function to pl/pgsql (Novice question) Richard Broersma Jr 13:06
Re: exception handling in postgres plpgsql Igor Neyman 13:17
Solved - best way: diary functions. Gary Stainburn 13:27
Re: CPU statistics Peter Eisentraut 13:54
Re: CPU statistics Jonah H. Harris 14:02
Re: Moving a simple function to pl/pgsql (Novice question) Paul Lambert 22:20

April 5, 2007

Thread Author Time
slow query Sumeet 03:17
Re: Very slow DELETE on 4000 rows of 55000 row table Bryce Nesbitt 04:17
Re: Very slow DELETE on 4000 rows of 55000 row table Richard Broersma Jr 04:46
Re: slow query A. Kretschmer 05:11
Re: Very slow DELETE on 4000 rows of 55000 row table Tom Lane 05:23
Re: slow query Tom Lane 05:27
Re: slow query A. Kretschmer 05:36
Re: slow query Tom Lane 05:47
Insert only if not found Shavonne Marietta Wijesinghe 08:38
Re: Insert only if not found A. Kretschmer 08:53
Re: Insert only if not found Shavonne Marietta Wijesinghe 09:24
Re: Insert only if not found Shavonne Marietta Wijesinghe 09:47
Re: Insert only if not found A. Kretschmer 10:05
Re: slow query Andrew Sullivan 13:33
LOG: unexpected EOF on client connection ezequias 14:50
Another date range join problem Gary Stainburn 15:17
Re: LOG: unexpected EOF on client connection Tom Lane 15:20
Re: Generating dates prior to generate_series Scott Marlowe 15:24
SOLVED - Another date range join problem Gary Stainburn 16:03
auto vacuuming Sumeet 17:42
Re: auto vacuuming Alvaro Herrera 17:51
Re: auto vacuuming Sumeet 18:00
Re: auto vacuuming Alvaro Herrera 18:19
Re: Insert only if not found Roger Tannous 22:47

April 6, 2007

Thread Author Time
Re: Insert only if not found Shavonne Marietta Wijesinghe 07:10
Update Field with function/data from other tables? paallen 16:57
dropping a schema and cross-schema dependencies George Pavlov 22:09
Re: dropping a schema and cross-schema dependencies Tom Lane 23:39

April 7, 2007

Thread Author Time
Re: dropping a schema and cross-schema dependencies George Pavlov 00:05
rowcount function in postgres??? Karthikeyan Sundaram 17:33
Re: rowcount function in postgres??? Michael Fuhr 17:51
Re: [SQL] rowcount function in postgres??? Rodrigo De León 17:54
Re: rowcount function in postgres??? Uwe C. Schroeder 18:58

April 8, 2007

Thread Author Time
MD5 sums of large objects Dirk Jagdmann 17:03
Re: MD5 sums of large objects Michael Fuhr 17:37
Question on pgpsql function Karthikeyan Sundaram 19:47
Re: [SQL] Question on pgpsql function Adrian Klaver 20:22
Re: Question on pgpsql function Tom Lane 23:20

April 9, 2007

Thread Author Time
Re: MD5 sums of large objects Dirk Jagdmann 00:07
Re: MD5 sums of large objects Michael Fuhr 01:07
Another question in functions Karthikeyan Sundaram 01:59
new idea sql4-en.narod.ru 06:42
Re: new idea Andrew Sullivan 12:21
Re: new idea Erik Jones 14:11
Re: new idea Andrew Sullivan 14:14
Re: Another question in functions Stephan Szabo 14:24
Re: MD5 sums of large objects Dirk Jagdmann 15:11
Re: new idea Erik Jones 15:52

April 10, 2007

Thread Author Time
Question about undefinably query... A. Kretschmer 14:05
EXECUTE in a funtion to return a VIEW object ID Wilkinson, Jim 14:34
Re: Question about undefinably query... Tom Lane 14:46
Re: A long-running transaction John Summerfield 16:41
Re: A long-running transaction Andrew Sullivan 16:55
Replace string PostgreSQL Admin 20:40
Re: A long-running transaction John Summerfield 21:54

April 11, 2007

Thread Author Time
update from and left join Tomasz Myrta 07:06
Re: A long-running transaction Andrew Sullivan 13:34
Re: A long-running transaction John Summerfield 14:23
Re: A long-running transaction Andrew Sullivan 15:49
Urgent help in bit_string data type Karthikeyan Sundaram 20:30
Re: [SQL] Urgent help in bit_string data type Joe 21:44
Re: [SQL] Urgent help in bit_string data type Karthikeyan Sundaram 22:01
Re: [SQL] Urgent help in bit_string data type Joe 23:00
Re: [SQL] Urgent help in bit_string data type Karthikeyan Sundaram 23:29

April 12, 2007

Thread Author Time
Re: [SQL] Urgent help in bit_string data type Joe 04:07
Re: Replace string A. Kretschmer 05:12
Re: Replace string Rodrigo De León 05:29
un-triviality is saved Dmitry Turin 11:23
Re: ERROR: column "crc" does not exist Bart Degryse 12:15
Re: ERROR: column "crc" does not exist A. Kretschmer 12:19
Re: ERROR: column "crc" does not exist George Weaver 12:21
Re: ERROR: column "crc" does not exist Andrew Sullivan 12:21
ERROR: column "crc" does not exist ezequias 12:23
replace EXCEPT by JOIN T E Schmitz 18:32
Re: Replace string PostgreSQL Admin 19:51
question on plpgsql block Karthikeyan Sundaram 22:44
Re: question on plpgsql block Peter Eisentraut 23:38

April 13, 2007

Thread Author Time
setting up a mirroring or replication database Karthikeyan Sundaram 00:39
Re: [SQL] setting up a mirroring or replication database Phillip Smith 00:50
Re: A long-running transaction John Summerfield 01:02
Re: question on plpgsql block A. Kretschmer 06:28
We all are looped on Internet: request + transport = invariant Dmitry Turin 07:58
How can I know if a row is Locked? Carlos Santos 11:27
Re: How can I know if a row is Locked? Marcin Stępnicki 11:48
Re: How can I know if a row is Locked? A. Kretschmer 11:48
Re: A long-running transaction Andrew Sullivan 11:49
Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan 15:09
Re: A long-running transaction Andrew Sullivan 16:20
Re: A long-running transaction Joe 16:42
Re: A long-running transaction Andrew Sullivan 17:01

April 16, 2007

Thread Author Time
i have prolem can you help me saytinh 03:48
quesion on functions calling from php Karthikeyan Sundaram 22:58

April 17, 2007

Thread Author Time
Re: quesion on functions calling from php Tommy Gildseth 06:08
Floating point type to store numbers Radhika Sambamurti 18:53
Re: Floating point type to store numbers Andrew Sullivan 19:04
Re: Floating point type to store numbers Milen A. Radev 19:10
Re: Floating point type to store numbers Richard Broersma Jr 19:18
Re: Floating point type to store numbers Radhika Sambamurti 20:28
Re: Floating point type to store numbers Radhika Sambamurti 20:33
Re: Floating point type to store numbers Radhika Sambamurti 20:36
Re: Floating point type to store numbers Andrew Sullivan 20:53
Re: Floating point type to store numbers Milen A. Radev 22:09

April 18, 2007

Thread Author Time
Windows postgres Senthil 08:42
Retrieve month from date in SQl query RPK 17:36
slowness when subselect uses DISTINCT Stuart McGraw 18:16
equiv of ascii() function for unicode? Stuart McGraw 18:16
Re: slowness when subselect uses DISTINCT Phillip Smith 22:43

April 19, 2007

Thread Author Time
Re: We all are looped on Internet: request + transport = invariant sql4-en 06:08
Re: We all are looped on Internet: request + transport = invariant Andrej Ricnik-Bay 06:26
Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan 13:48
Re: slowness when subselect uses DISTINCT Stuart McGraw 14:20
Doing a conditional insert/update Markus Holzer 18:27
Re: Doing a conditional insert/update Andrew Sullivan 18:55
Re: Doing a conditional insert/update Rodrigo De León 18:58
Re: slowness when subselect uses DISTINCT Phillip Smith 22:52

April 20, 2007

Thread Author Time
many 'OR' in WHERE-condition A. Kretschmer 05:13
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 09:08
Re: many 'OR' in WHERE-condition Richard Huxton 11:03
Re: We all are looped on Internet: request + transport = invariant Richard Huxton 11:14
Re: We all are looped on Internet: request + transport = invariant Bart Degryse 11:14
Re: many 'OR' in WHERE-condition A. Kretschmer 11:29
Re: many 'OR' in WHERE-condition Richard Huxton 11:59
Retrieve month from date Rohit Khare 12:19
Re: many 'OR' in WHERE-condition A. Kretschmer 12:20
Re: Retrieve month from date Bart Degryse 12:29
Re: Retrieve month from date A. Kretschmer 12:35
Re: We all are looped on Internet: request + transport = invariant Joe 12:42
Re: We all are looped on Internet: request + transport = invariant Richard Huxton 12:50
Re: We all are looped on Internet: request + transport = invariant Achilleas Mantzios 13:14
Re: We all are looped on Internet: request + transport = invariant Joe 13:21
Function to return a multiple colmn table or view Wilkinson, Jim 14:13
Re: Function to return a multiple colmn table or view Richard Huxton 14:32
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 14:49
Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan 15:52
Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin 15:59
Re: Retrieve month from date RPK 16:13
Re: Retrieve month from date Rodrigo De León 16:33
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 16:52
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 17:04
Re: Retrieve month from date RPK 17:30
Re: Retrieve month from date A. Kretschmer 17:43
Re: Retrieve month from date Scott Marlowe 17:46
Question on interval Wei Weng 18:53
Re: Question on interval Rodrigo De León 19:29
Re: Question on interval Michael Glaesemann 19:35
Re: Question on interval Scott Marlowe 20:11

April 21, 2007

Thread Author Time
Re: Question on interval Steve Crawford 00:38
Re: Floating point type to store numbers Lew 05:20
Regular Expression Data Type Richard Doust 16:03
Split String Into Multiple Records Aaron Bono 23:47

April 22, 2007

Thread Author Time
Re: Split String Into Multiple Records Tom Lane 02:13
Re: Split String Into Multiple Records Aaron Bono 02:18

April 23, 2007

Thread Author Time
Re: Windows postgres Paul Lambert 04:34
Re: We all are looped on Internet: request +transport = invariant Bart Degryse 06:46
Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Bart Degryse 07:00
Re: Retrieve month from date in SQl query Michael Fuhr 07:41
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 08:20
Re: We all are looped on Internet: request+transport = invariant Bart Degryse 10:18
Re: We all are looped on Internet: request + transport = invariant Joe 11:57
plperlu hash problem Bart Degryse 15:09
Large journal as psql table. Good idea? Triggering. Bryce Nesbitt 23:12
Large journal as psql table. Good idea? Triggering. Phillip Smith 23:27

April 24, 2007

Thread Author Time
Re: Large journal as psql table. Good idea? Triggering. chester c young 00:56
Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin 11:58
Fwd: Re[2]: We all are looped on Internet: request+transport = invariant Dmitry Turin 12:00
Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Dmitry Turin 12:02
hi Penchalaiah P. 12:09
How to get text representation of composite value? David Flegl 12:12
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 12:31
Re: Fwd: Re[2]: We all are looped on Internet:request+transport = invariant Dmitry Turin 12:35
Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton 12:40
Re: hi Wilkinson, Jim 12:45
Re: hi David Flegl 13:06
Re: We all are looped on Internet: request + transport = invariant Joe 13:55
Re: hi Ragnar 15:05
Re: Function to return a multiple colmn table or view Richard Huxton 15:52
Re: hi Stephan Szabo 16:41
plpgsql array looping Richard Albright 20:42

April 25, 2007

Thread Author Time
Query Join Performance Aaron Bono 01:26
Re: hi saji varghese 04:40
Re: hi Phillip Smith 05:19
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 07:47
Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton 08:55
Which function transform x,y to latitude/longitude? Nemo Terry 09:02
Re: We all are looped on Internet: request + transport = invariant Joe 09:34
Re: plpgsql array looping John DeSoi 13:38

Browse Archives

Prev | Next