pgsql-sql since 2007-09-04 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

Sept. 4, 2007

Thread	Author	Time
Re: Constraints for grouping	PostgreSQL Admin	00:21
Cast on character columns in views	Luiz K. Matsumura	03:44
Re: Execute SQL statements with 'context'/predefined variables	chester c young	04:08
Re: Cast on character columns in views	Richard Broersma Jr	04:23
Re: Request into several DBMS simultaneously on DDL and DML	Dmitry Turin	04:25
Difference between "foo is false" and "foo=false"? Partial index on boolean. 📎	Bryce Nesbitt	04:43
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.	Tom Lane	04:56
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean. 📎	Bryce Nesbitt	05:07
Re: Cast on character columns in views	Luiz K. Matsumura	06:38
Re: Cast on character columns in views	Luiz K. Matsumura	07:33
Partial index on boolean - Sometimes fails to index scan 📎	Bryce Nesbitt	07:51
EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?	Marc Mamin	08:35
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.	Richard Huxton	08:43
Use of delete...returning in function problem	Bart Degryse	09:03
Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?	Dirk Jagdmann	09:38
8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution 📎	Aleksandr Vinokurov	10:37
Re: Use of delete...returning in function problem	Richard Huxton	10:45
Re: Cast on character columns in views	Richard Broersma Jr	11:03
Re: Cast on character columns in views	Richard Broersma Jr	11:08
Re: Use of delete...returning in function problem	Bart Degryse	12:09
Re: How to influence the planner	Scott Marlowe	14:11
Re: Partial index on boolean - Sometimes fails to index scan 📎	Bryce Nesbitt	14:40
Re: Cast on character columns in views	Tom Lane	15:03
Trigger to change different row in same table	PostgreSQL Admin	15:13
Re: Trigger to change different row in same table	PostgreSQL Admin	15:27
Re: Use of delete...returning in function problem	Tom Lane	15:55
Re: How to influence the planner	Richard Ray	15:56

Sept. 5, 2007

Thread	Author	Time
work hour calculations	novice	03:45
Re: work hour calculations	Raj A	03:54
Re: work hour calculations	novice	03:56
Re: work hour calculations	A. Kretschmer	06:45
ISO time zone format	Sabin Coanda	07:30
Re: 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution 📎	Aleksandr Vinokurov	07:57
Re: ISO time zone format	Achilleas Mantzios	07:58
Re: ISO time zone format	Richard Huxton	08:16
Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ?	Marc Mamin	08:22
tsearch2 query question	roy simkes	08:33
Re: ISO time zone format	Sabin Coanda	13:09
Re: ISO time zone format	Richard Huxton	14:32
recursive query	Joel Fradkin	14:47
Re: ISO time zone format	Sabin Coanda	14:54

Sept. 6, 2007

Thread	Author	Time
How to use serial variable to insert into muiti-recrods?	hu js	07:11
Re: How to use serial variable to insert into muiti-recrods?	Ashish Karalkar	07:48
Re: How to use serial variable to insert into muiti-recrods?	Milen A. Radev	07:49
Re: How to use serial variable to insert into muiti-recrods?	Richard Huxton	08:16
Re: How to use serial variable to insert into muiti-recrods?	Jean-David Beyer	11:45

Sept. 7, 2007

Thread	Author	Time
to_date function	anru chen	05:22
Re: to_date function	Phillip Smith	06:17
Re: to_date function	A. Kretschmer	06:35
Failing join with set returning function	Bart Degryse	09:51
Re: work hour calculations	Filip Rembiałkowski	12:13
Re: Failing join with set returning function	[email protected]	13:04
SERIAL type's sequence is double-called or ?	Aleksandr Vinokurov	13:40
Re: to_date function	Tom Lane	14:25
Re: SERIAL type's sequence is double-called or ?	Richard Huxton	14:38
Re: to_date function	A. Kretschmer	17:41

Sept. 9, 2007

Thread	Author	Time
Re: work hour calculations	novice	01:06
Re: work hour calculations	Filip Rembiałkowski	11:01

Sept. 10, 2007

Thread	Author	Time
Function Volatility	Fernando Hevia	00:24
postgresql HEAD build failure	John Summerfield	00:52
Re: postgresql HEAD build failure	Alvaro Herrera	01:01
Re: postgresql HEAD build failure	John Summerfield	01:36
Re: postgresql HEAD build failure	Alvaro Herrera	01:43
Re: Function Volatility	Tom Lane	02:15
Re: postgresql HEAD build failure	Tom Lane	02:51
Re: Function Volatility	Fernando Hevia	13:47
Re: postgresql HEAD build failure	Erik Jones	14:59

Sept. 11, 2007

Thread	Author	Time
Does postgresql8.2 supports multithreading?	Jyoti Seth	07:08
Re: Does postgresql8.2 supports multithreading?	A. Kretschmer	07:31
Re: Does postgresql8.2 supports multithreading?	Dave Page	08:11
select sum within transaction problem	Bart Degryse	15:45
Re: Does postgresql8.2 supports multithreading?	Josh Tolley	17:29
Simple Query?	Koen Bok	21:27
Re: Simple Query?	Rodrigo De León	21:46
Re: Simple Query?	Richard Broersma Jr	21:59

Sept. 12, 2007

Thread	Author	Time
Extracting hostname from URI column	ogjunk-pgjedan	00:06
Re: Extracting hostname from URI column	Paul Lambert	00:22
Re: Extracting hostname from URI column	chester c young	00:42
Re: select sum within transaction problem	Tom Lane	01:09
Re: Extracting hostname from URI column	Paul Lambert	01:13
Re: Extracting hostname from URI column	Andrej Ricnik-Bay	02:19
Re: Extracting hostname from URI column	Paul Lambert	02:38
Re: Extracting hostname from URI column	ogjunk-pgjedan	03:16
Re: Extracting hostname from URI column	chester c young	03:47
Re: Extracting hostname from URI column	Paul Lambert	03:53
Re: Extracting hostname from URI column	chester c young	03:56
Re: Extracting hostname from URI column	ogjunk-pgjedan	03:58
Re: Extracting hostname from URI column	Paul Lambert	04:03
Re: Extracting hostname from URI column	Alvaro Herrera	12:52
Re: Simple Query?	Osvaldo Rosario Kussama	14:22

Sept. 13, 2007

Thread	Author	Time
Index usage in bitwise operation context	W.Alphonse HAROUNY	12:34
Re: Index usage in bitwise operation context	Gregory Stark	22:55

Sept. 14, 2007

Thread	Author	Time
Optimize querry sql	Stanislas de Larocque	08:31
Optimize querry sql	Stanislas de Larocque	08:32
Re: Optimize querry sql	A. Kretschmer	08:49
Re: Optimize querry sql	Stanislas de Larocque	10:26
Re: Optimize querry sql	A. Kretschmer	11:55
Re: Optimize querry sql	hubert depesz lubaczewski	11:59
Optimize querry sql	Stanislas de Larocque	13:02
Re: Optimize querry sql	hubert depesz lubaczewski	13:36
Re: Optimize querry sql	Scott Marlowe	13:36
Re: Optimize querry sql	A. Kretschmer	14:52
Re: Optimize querry sql	Scott Marlowe	15:17

Sept. 15, 2007

Thread	Author	Time
Re: Optimize querry sql	Michael Glaesemann	14:25

Sept. 16, 2007

Thread	Author	Time
Format intervall as hours/minutes etc	Andreas Joseph Krogh	11:00
Re: Format intervall as hours/minutes etc	Andreas Kretschmer	11:14
Re: Format intervall as hours/minutes etc	Andreas Joseph Krogh	11:27
Re: Format intervall as hours/minutes etc	Tom Lane	15:41
Re: Format intervall as hours/minutes etc	Shane Ambler	16:45
Re: Format intervall as hours/minutes etc	Andreas Joseph Krogh	19:32
Re: Extracting hostname from URI column	Paul Lambert	22:54
Re: Extracting hostname from URI column	Gregory Stark	23:18

Sept. 17, 2007

Thread	Author	Time
Re: Optimize querry sql	Stanislas de Larocque	07:17
Re: Optimize querry sql	hubert depesz lubaczewski	07:25
Re: Format interval as hours/minutes etc	Oliver Elphick	12:13
Re: Extracting hostname from URI column	Andrew Sullivan	14:43

Sept. 18, 2007

Thread	Author	Time
SQL performance help: self join or static var	Steve Midgley	00:42
error dropping operator	Sabin Coanda	10:55
Table transform query	Philippe Lang	13:12
Re: Table transform query	Philippe Lang	13:49
Re: Table transform query	Rodrigo De León	13:51
Re: error dropping operator	Tom Lane	15:13

Sept. 19, 2007

Thread	Author	Time
Re: Extracting hostname from URI column	John Summerfield	05:32
Re: Table transform query	Nis Jørgensen	08:13
Re: Speeding up schema changes	Decibel!	15:04
Re: Speeding up schema changes	Gregory Stark	17:43

Sept. 21, 2007

Thread	Author	Time
Re: Table transform query	Philippe Lang	08:25
Many databases	Stefan Arentz	22:39
Re: Many databases	Stefan Arentz	23:16
Re: Many databases	Richard Broersma Jr	23:33

Sept. 22, 2007

Thread	Author	Time
Intermittent Empty return	John Mulkerin	20:31
Re: Intermittent Empty return	Tom Lane	20:41
Re: Intermittent Empty return	John Mulkerin	22:09
Re: Intermittent Empty return	Scott Marlowe	23:14

Sept. 23, 2007

Thread	Author	Time
Re: Intermittent Empty return	John Mulkerin	14:29
How pull	Matt Magoffin	22:26

Sept. 24, 2007

Thread	Author	Time
Re: How pull	Filip Rembiałkowski	01:15
Re: Many databases	Erik Jones	04:56
Re: How pull	Matt Magoffin	07:37
foreign key problem	ivan marchesini	12:34
Re: Many databases	Erik Jones	15:37

Sept. 25, 2007

Thread	Author	Time
problems with copy	chester c young	00:38
Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]	Alessandra Bilardi	17:28

Sept. 26, 2007

Thread	Author	Time
Re: foreign key problem	Ashish Karalkar	13:25

Sept. 27, 2007

Thread	Author	Time
Problems with bulk update	Venelin Arnaudov	08:21
Re: Problems with bulk update	Richard Huxton	09:27
Re: Problems with bulk update	Venelin Arnaudov	10:38

Sept. 28, 2007

Thread	Author	Time
to restore database in schema	Penchalaiah P.	10:00
Re: to restore database in schema	Richard Huxton	10:19
Re: problems with copy	Luis Carlos Ferreira	16:21

Oct. 1, 2007

Thread	Author	Time
Populate unique column with default value	Jon Horsman	15:24
Re: Populate unique column with default value	Jon Horsman	15:33
Re: Populate unique column with default value	Rodrigo De Le�	15:39
Re: Populate unique column with default value	Jon Horsman	15:51

Oct. 2, 2007

Thread	Author	Time
Finding broken regex'es	Enrico Weigelt	20:23
Re: Finding broken regex'es	Erik Jones	21:36

Oct. 3, 2007

Thread	Author	Time
Why does the sequence skip a number with generate_series?	Jeff Frost	00:20
Re: Finding broken regex'es	Tom Lane	03:48
Re: Finding broken regex'es	Erik Jones	05:43
Re: Finding broken regex'es	Tom Lane	06:03
Re: Finding broken regex'es	Dawid Kuroczko	13:36
Re: Finding broken regex'es	Filip Rembiałkowski	14:40
Re: Finding broken regex'es	Dawid Kuroczko	15:41
Need help with CASE statement in Function	Hengky Lie	16:44
Re: Need help with CASE statement in Function	Dawid Kuroczko	17:04
Re: Need help with CASE statement in Function	Richard Broersma Jr	17:07

Oct. 4, 2007

Thread	Author	Time
field separator problem	Tena Sakai	00:13
Re: field separator problem	Michael Fuhr	00:54
Re: Why does the sequence skip a number with generate_series?	Stephan Szabo	01:06
Re: field separator problem	Tena Sakai	02:25
Postgres Array Traversing Problem	yogesh	09:26
Rule Error	Hengky Lie	11:22
Re: Rule Error	Richard Huxton	12:53
Re: Rule Error	Bart Degryse	12:57
Re: Rule Error	A. Kretschmer	13:00
Re: Why does the sequence skip a number with generate_series?	Shane Ambler	14:25
Re: [HACKERS] Why does the sequence skip a number with generate_series?	Alvaro Herrera	14:46
Re: [HACKERS] Why does the sequence skip a number with generate_series?	Tom Lane	15:18
What SQL is running against my DB?	Tore Lukashaugen	17:39
Re: What SQL is running against my DB?	Andreas Kretschmer	18:18
Re: Rule Error	Hengky Lie	23:59

Oct. 5, 2007

Thread	Author	Time
Re: Rule Error	A. Kretschmer	04:56
Re: Postgres Array Traversing Problem	Dawid Kuroczko	08:55
pg_dump question	Judith	16:58
Re: pg_dump question	Erik Jones	21:11
valid query runs forever?	Aroon Pahwa	21:33

Oct. 6, 2007

Thread	Author	Time
Re: [SQL] Why does the sequence skip a number with generate_series?	Shane Ambler	00:50

Oct. 7, 2007

Thread	Author	Time
Re: SQL query question	Rodrigo De León	19:16

Oct. 8, 2007

Thread	Author	Time
Get different sums from the same table in one query	Dani Castaños	10:49
Re: Get different sums from the same table in one query	A. Kretschmer	10:54
Re: Get different sums from the same table in one query	Peter Childs	11:32
Re: Get different sums from the same table in one query	Richard Huxton	11:37
Re: Get different sums from the same table in one query	A. Kretschmer	11:59
Re: UNIQUEness and time interval	Rodrigo De León	14:46

Oct. 9, 2007

Thread	Author	Time
array handling on 8.0.3	Daniel Drotos	13:11
Re: finding unused indexes?	George Pavlov	18:58
Re: array handling on 8.0.3	Daniel Drotos	19:28
Re: array handling on 8.0.3	Daniel Drotos	19:36

Oct. 10, 2007

Thread	Author	Time
Re: finding unused indexes?	Tom Lane	13:35
Re: finding unused indexes?	George Pavlov	17:13

Browse Archives

Prev | Next