pgsql-sql since 2004-01-29 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

Jan. 29, 2004

Thread Author Time
LEFT JOIN on one and/or another column Octavio Alvarez 04:27
SQL Query for Top Down fetching of childs Kumar 06:11
auto_insert jodi 08:27
Re: auto_insert Viorel Dragomir 08:34
Re: time series data azwa 09:05
Re: SQL Query for Top Down fetching of childs Richard Huxton 10:27
[No subject] MUKTA 12:02
query not using index for descending records? email lists 12:18
Re: SQL Query for Top Down fetching of childs Kumar 12:22
Re: limit 1 and functional indexes Bruno Wolff III 12:52
Re: LEFT JOIN on one and/or another column Bruno Wolff III 13:00
[No subject] MUKTA 13:08
Re: Viorel Dragomir 13:11
Re: query not using index for descending records? Bruno Wolff III 13:18
Re: query not using index for descending records? Achilleus Mantzios 13:29
Re: email 13:36
Re: query not using index for descending records? Bruno Wolff III 14:06
Re: MUKTA 14:15
Re: query not using index for descending records? Achilleus Mantzios 15:01
How to retrieve N lines of a text field. Chris Travers 15:01
Re: limit 1 and functional indexes Alexandra Birch 15:02
Re: limit 1 and functional indexes Bruno Wolff III 15:11
Re: [SQL] limit 1 and functional indexes Bruno Wolff III 15:43
Re: How to retrieve N lines of a text field. Tom Lane 15:50
Re: query not using index for descending records? Stephan Szabo 16:05
java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan 16:34
Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios 16:50
Re: query not using index for descending records? Tom Lane 17:24
Re: How to retrieve N lines of a text field. Joe Conway 17:52
Re: query not using index for descending records? Stephan Szabo 18:27
Re: LEFT JOIN on one and/or another column (thanks) Octavio Alvarez 18:40
Re: query not using index for descending records? Tom Lane 18:40
Re: On the performance of views Josh Berkus 18:41
Re: On the performance of views Bill Moran 19:12
Re: [PERFORM] Set-Returning Functions WAS: On the performance of views Josh Berkus 19:21
Re: [PERFORM] Set-Returning Functions WAS: On the performance of Bill Moran 19:44
Re: java.lang.StringIndexOutOfBoundsException: String index mohan 20:50
Re: [PERFORM] Set-Returning Functions WAS: On the performance of views Josh Berkus 23:17
Re: java.lang.StringIndexOutOfBoundsException: String index Josh Berkus 23:22

Jan. 30, 2004

Thread Author Time
Re: [PERFORM] Set-Returning Functions WAS: On the performance of Bill Moran 01:07
Re: Chris Travers 03:03
Re: limit 1 and functional indexes Greg Stark 06:07
Re: On the performance of views Shridhar Daithankar 07:03
locking problem cheater cheater 07:41
update more than 1 table (mysql to postgres) treeml 08:19
Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios 09:00
Re: limit 1 and functional indexes: SOLVED Alexandra Birch 09:06
Re: [SQL] java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) Paul Thomas 09:10
Re: [SQL] java.lang.StringIndexOutOfBoundsException: String Kris Jurka 09:27
Re: limit 1 and functional indexes: SOLVED Greg Stark 09:56
Empty String Comparison Standard compliant? Christoph Haller 13:12
Re: Empty String Comparison Standard compliant? Tom Lane 15:18
Re: Empty String Comparison Standard compliant? Stephan Szabo 15:29
PROBLEM SOLVEDRe: java.lang.StringIndexOutOfBoundsException: String index mohan 16:04

Jan. 31, 2004

Thread Author Time
Re: query not using index for descending records? email lists 05:09
Mechanics of UpDate:Cascade beyaNet Consultancy 10:45
Mechanics of Update:Cascade beyaRecords - The home Urban music 10:50
Re: 'select nextval('seq_name');' in a function ? Stephan Szabo 15:23
Re: Mechanics of Update:Cascade Stephan Szabo 15:26
Re: Mechanics of Update:Cascade Richard Huxton 17:42
Re: Sometimes referential integrity seems not to work Stephan Szabo 20:45
REPLACE LawyerKill 21:50
Re: Sometimes referential integrity seems not to work Tom Lane 23:40

Feb. 1, 2004

Thread Author Time
Re: Sometimes referential integrity seems not to work Stephan Szabo 05:48
Re: An order by question Michael Fuhr 13:34
Re: An order by question Tomasz Myrta 17:22
Re: An order by question Michael Fuhr 19:11
Re: Executing dynamic queries (EXECUTE) Tomasz Myrta 19:43

Feb. 2, 2004

Thread Author Time
Re: Help! Error with postgresql! Paul Hart 02:33
Re: update more than 1 table (mysql to postgres) postgres 02:46
Re: update more than 1 table (mysql to postgres) Christopher Browne 03:21
Re: update more than 1 table (mysql to postgres) Tom Lane 04:26
Re: Executing dynamic queries (EXECUTE) Carla Mello 10:37
SQL query Paul Czubilinski 15:10
Re: Richard Huxton 15:32
Re: Sometimes referential integrity seems not to work Jan Wieck 16:54
Re: Sometimes referential integrity seems not to work scott.marlowe 18:40
Re: Sometimes referential integrity seems not to work Rod Taylor 18:44
Novice SQL Question Terry Lee Tucker 22:38
Re: Novice SQL Question Terry Lee Tucker 23:00

Feb. 3, 2004

Thread Author Time
Re: Novice SQL Question Tom Lane 03:14
Outer join Russell Shaw 06:28
Re: Outer join Tomasz Myrta 06:35
Re: Outer join Russell Shaw 06:44
request to plsql tutorial arun raj 13:06
Re: Sometimes referential integrity seems not to work Jan Wieck 13:32
Re: locking problem Christoph Haller 15:08
date function problem mohan 15:51
Re: date function problem Larry Rosenman 16:01
Re: date function problem Tomasz Myrta 16:03
Re: Sometimes referential integrity seems not to work scott.marlowe 16:27
Re: Sometimes referential integrity seems not to work scott.marlowe 16:31
[No subject] Prashanthi Muthyala 17:46
Re: scott.marlowe 20:36
Re: Richard Huxton 20:51
Re: request to plsql tutorial Richard Huxton 20:54
Re: Jan Wieck 22:52

Feb. 4, 2004

Thread Author Time
Re: SQL query daq 07:43
Update from same table Jürgen Cappel 16:46
Re: Update from same table Josh Berkus 17:28
TIME ZONE SQL Raman 17:57
Re: TIME ZONE SQL Richard Huxton 20:03

Feb. 5, 2004

Thread Author Time
Slow sub-selects, max and count(*) Richard Sydney-Smith 01:48
Re: Slow sub-selects, max and count(*) Josh Berkus 05:13
Re: Slow sub-selects, max and count(*) Iain 06:42
Re: Slow sub-selects, max and count(*) Richard Sydney-Smith 07:53
Re: TIME ZONE SQL Raman 08:28
Re: TIME ZONE SQL Richard Huxton 11:00
Re: TIME ZONE SQL Raman Garg 14:59
Re: TIME ZONE SQL Richard Huxton 16:31
Re: TIME ZONE SQL Tom Lane 16:54
Could not convert UTF-8 to ISO8859-1 Chris Anderson 23:04

Feb. 6, 2004

Thread Author Time
Re: Slow sub-selects, max and count(*) Bruno Wolff III 03:39
Re: Slow sub-selects, max and count(*) Josh Berkus 03:59
Seq scan on zero-parameters function Octavio Alvarez 07:19
[Fwd: Re: [PERFORM] Seq scan on zero-parameters function] Tomasz Myrta 07:28
Re: Seq scan on zero-parameters function Octavio Alvarez 08:43
Re: Seq scan on zero-parameters function Richard Huxton 08:50
Re: [PERFORM] Seq scan on zero-parameters function Tomasz Myrta 08:55
unsubscribe jan bok 11:33
alias problem on join Gary Stainburn 11:38
Re: alias problem on join Tomasz Myrta 11:46
Re: Storing a range of numbers CoL 13:56
Re: Seq scan on zero-parameters function Tom Lane 14:55
Re: Cool ORDER BY feature Jeff Boes 16:17
unsubscribe Mona H. Kapadia 17:15
Re: [PERFORM] Seq scan on zero-parameters function Octavio Alvarez 17:24
Re: Storing a range of numbers Chris Fisher 20:17

Feb. 7, 2004

Thread Author Time
techniques for manual ordering of data ? Peter Galbavy 10:47
Re: Storing a range of numbers Tom Lane 20:53

Feb. 8, 2004

Thread Author Time
determining how many products are in how many categories David Garamond 17:09

Feb. 9, 2004

Thread Author Time
Disable/Enable Trigger? Philippe Lang 07:46
Implementation of a bag pattern using rules Mark Gibson 12:42
Re: Implementation of a bag pattern using rules Robert Creager 13:02
Re: Implementation of a bag pattern using rules Mark Gibson 13:49
Index not used - now me Christoph Haller 13:50
Re: Index not used - now me Paul Thomas 14:28
Re: Implementation of a bag pattern using rules Richard Sydney-Smith 14:54
timestamptz - problems Mark Roberts 15:02
Re: Index not used - now me Greg Stark 15:43
Re: Index not used - now me Christoph Haller 16:02
Re: Implementation of a bag pattern using rules Tom Lane 16:09
Re: timestamptz - problems Christopher Browne 16:18
Re: Index not used - now me Tom Lane 16:38
Re: techniques for manual ordering of data ? scott.marlowe 17:00
unsubscribe Mona 17:22
Re: Implementation of a bag pattern using rules Mark Gibson 17:24
Re: Index not used - now me Paul Thomas 17:27
Re: Implementation of a bag pattern using rules Mark Gibson 17:42
Multiple outer join on same table Marco Lazzeri 18:12
umlimited arguments on function Christian Hergert 19:49
returning multiple resultset? ismail 23:27

Feb. 10, 2004

Thread Author Time
Re: Implementation of a bag pattern using rules Robert Creager 03:25
Error in declaring %rowtype for recurrence Kumar 06:41
Re: Bug or Feature? Tom Lane 08:29
Re: Error in declaring %rowtype for recurrence Tom Lane 08:32
Re: Error in declaring %rowtype for recurrence Kumar 09:44
writing a dynamic sql Senthil Kumar S 09:48
Trace for postgreSQL beyaNet Consultancy 12:04
Unique Constraint with foreign Key mohan 17:03
max timestamp Michael Sterling 18:14
Bug or Feature? Herbert R. Ambos 19:48
Re: max timestamp boyd (remove_) tb_moore_@bealenet_.com 19:50
Re: Unique Constraint with foreign Key Bruno Wolff III 20:15
Unable to convert date to tm Ramiro Arenas R 20:45

Feb. 11, 2004

Thread Author Time
Elegant way to monitor for changes in a trigger and migrate record to history table David B 01:18
Re: Elegant way to monitor for changes in a trigger and migrate Mark Gibson 08:39
bytea or blobs? beyaNet Consultancy 13:05
unsubscribe Mona 19:45
Re: Multiple outer join on same table Markus Bertheau 21:23
Re: Unique Constraint with foreign Key Greg Patnude 23:33
Re: determining how many products are in how many categories Greg Patnude 23:43

Feb. 12, 2004

Thread Author Time
7.4 - FK constraint performance ow 00:06
Re: 7.4 - FK constraint performance Stephan Szabo 01:06
Re: 7.4 - FK constraint performance Tom Lane 03:12
cascade delete sad 07:33
Re: cascade delete sad 08:45
ORDER BY TIMESTAMP_column ASC, NULL first Fredrik Wendt 10:06
Function Sumita Biswas (sbiswas) 11:40
How to avoid nulls while writing string for dynamic query Kumar 12:31
Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta 12:43
Re: 7.4 - FK constraint performance ow 14:05
Re: array_lower /array_prepend doubt Bruce Momjian 15:10
Re: 7.4 - FK constraint performance Stephan Szabo 15:37
Re: 7.4 - FK constraint performance ow 15:53
Re: 7.4 - FK constraint performance Tom Lane 15:54
Re: 7.4 - FK constraint performance Stephan Szabo 16:04
test beyaRecords - The home Urban music 17:05
Re: 7.4 - FK constraint performance ow 21:49
Re: array_lower /array_prepend doubt Joe Conway 23:25
Re: array_lower /array_prepend doubt Bruce Momjian 23:29

Feb. 13, 2004

Thread Author Time
Re: 7.4 - FK constraint performance Tom Lane 00:00
Re: 7.4 - FK constraint performance ow 00:25
Re: 7.4 - FK constraint performance Tom Lane 00:42
Re: 7.4 - FK constraint performance ow 01:03
Re: 7.4 - FK constraint performance Tom Lane 01:10
Re: 7.4 - FK constraint performance ow 01:22
nextval problem Ivo Anon 01:54
Index question David Witham 02:30
Re: 7.4 - FK constraint performance Rod Taylor 02:53

Browse Archives

Prev | Next