pgsql-sql before 2007-10-24 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. 7, 2007

Thread	Author	Time
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
Computed table name in function	Ray Madigan	17:59
Re: Computed table name in function	Scott Marlowe	18:10
Re: Computed table name in function	Ray Madigan	18:19
Re: Computed table name in function	Daniel Drotos	18:50
Re: Computed table name in function	Richard Huxton	18:52
Refactored queries needing validation of syntactic equivalence 📎	Mike Adams	23:25

Oct. 11, 2007

Thread	Author	Time
seg data type	TJ O'Donnell	04:59
Re: Refactored queries needing validation of syntactic equivalence	Richard Huxton	07:24
Accessing field of OLD in trigger	Daniel Drotos	12:17

Oct. 12, 2007

Thread	Author	Time
Accessing field of OLD in trigger	Daniel Drotos	10:00
Re: Accessing field of OLD in trigger	Josh Trutwin	13:18
How to escape a memo field as a binary value in postgresql	rdyes	14:06
OT: array_accum equivalent in Oracle	Andreas Joseph Krogh	14:16
Re: OT: array_accum equivalent in Oracle	Jonah H. Harris	15:02
Re: OT: array_accum equivalent in Oracle	Andreas Joseph Krogh	15:43
Re: OT: array_accum equivalent in Oracle	Jonah H. Harris	15:55
Re: Accessing field of OLD in trigger	Erik Jones	16:17

Oct. 13, 2007

Thread	Author	Time
Re: Refactored queries needing validation of syntactic equivalence	Mike Adams	17:44

Oct. 16, 2007

Thread	Author	Time
Re: Refactored queries needing validation of syntactic equivalence	Richard Huxton	08:27
Inconsistent sql result	Patrick De Zlio	10:00
Re: Inconsistent sql result	Gerardo Herzig	16:32
Having difficulty writing a "best-fit" query..	Jamie Tufnell	16:46
Re: Having difficulty writing a "best-fit" query..	Rodrigo De León	17:11
Re: Having difficulty writing a "best-fit" query..	Richard Broersma Jr	17:14
Re: Having difficulty writing a "best-fit" query..	Harald Fuchs	17:32
Re: Having difficulty writing a "best-fit" query..	Michael Glaesemann	17:34
what's wrong with my date comparison?	Tena Sakai	17:57
Re: what's wrong with my date comparison?	Tena Sakai	18:00
Re: what's wrong with my date comparison?	Andrew Sullivan	18:04
Re: what's wrong with my date comparison?	Michael Glaesemann	18:09
Re: what's wrong with my date comparison?	Tom Lane	20:53

Oct. 17, 2007

Thread	Author	Time
when inserting to table, text type parameter become NULL (after big assignment to this parameter)	Sofer, Yuval	07:09
two queryes in a single tablescan	Stefano Dal Pra	12:30
Re: two queryes in a single tablescan	Heikki Linnakangas	13:00
Re: two queryes in a single tablescan	Steinar H. Gunderson	13:15
Re: two queryes in a single tablescan	Stefano Dal Pra	13:21
Re: two queryes in a single tablescan	Heikki Linnakangas	13:39
[No subject]	Boergesson, Cheryl	18:49

Oct. 18, 2007

Thread	Author	Time
Re: two queryes in a single tablescan	李彦 Ian Li	02:24

Oct. 20, 2007

Thread	Author	Time
backup database tablespace with rsync?	chester c young	02:11
Re: Refactored queries needing validation of syntactic equivalence	Mike Adams	05:45
Re: backup database tablespace with rsync?	Scott Marlowe	09:01
Re: [SQL] two queryes in a single tablescan	Markus Schaber	10:58
Re: [SQL] two queryes in a single tablescan	Andreas Kretschmer	17:19
Re: [SQL] two queryes in a single tablescan	Erik Jones	22:02

Oct. 23, 2007

Thread	Author	Time
request for help with COPY syntax	Chuck D.	16:19
Re: request for help with COPY syntax	Fernando Hevia	16:44
Re: request for help with COPY syntax	Andrew Sullivan	16:46

Browse Archives

Prev | Next