pgsql-sql before 2004-04-23 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 7, 2004

Thread Author Time
Re: Function To Log Changes Erik Thiele 09:42
Counting rows from two tables in one query Stefan Weiss 10:06
setting a non-standard date format for the duration of a session Cris Carampa 12:47
Re: SQL Standatd Ricardo Vaz Mannrich 13:44
Re: SQL Standatd Bruce Momjian 14:26
Re: distinct values without seq scan Josh Berkus 15:43
varray? table of varchar? Postgres User 16:15
notify and leaks? Theodore Petrosky 16:30
Crypt() encryption Christina Zhang 17:01
Re: notify and leaks? Tom Lane 18:27
Row count after SELECT INTO? Alexander M. Pravking 19:04
Re: Help with COPY command Tony Reina 19:32
Re: SQL Standatd Martin Marques 21:16
Re: SQL Standatd Bruce Momjian 21:59
Re: SQL Standatd Joe Conway 22:39

April 8, 2004

Thread Author Time
Re: SQL Standatd Bruce Momjian 00:25
pgsql multi-database queries yek ching 07:52
Encoding and result string length kumar 09:32
Re: Encoding and result string length Richard Huxton 11:00
SQL challenge--top 10 for each key value? Jeff Boes 19:55
Re: SQL challenge--top 10 for each key value? Greg Stark 23:33

April 9, 2004

Thread Author Time
Re: SQL challenge--top 10 for each key value? Rod Taylor 03:31
Re: SQL challenge--top 10 for each key value? Tom Lane 06:11
Re: could not devise a query plan SZŰCS Gábor 12:23
hi sir urgent..required a Query 📎 Rajeev Chaudhary, Noida 12:28
Utility of recursive queries? James Robinson 14:33
Re: SQL challenge--top 10 for each key value? Josh Berkus 16:06
Re: Utility of recursive queries? Josh Berkus 16:07
Re: Utility of recursive queries? Tom Lane 16:35
Re: SQL challenge--top 10 for each key value? Greg Stark 22:43

April 10, 2004

Thread Author Time
Re: Crypt() encryption Bruce Momjian 01:06
Re: pgsql multi-database queries scott.marlowe 01:23
Re: Counting rows from two tables in one query Greg Sabino Mullane 01:28
Re: SQL challenge--top 10 for each key value? Rod Taylor 01:29
Re: SQL challenge--top 10 for each key value? Greg Sabino Mullane 14:35
Re: Counting rows from two tables in one query Bruno Wolff III 15:09
Re: hi sir urgent..required a Query Josh Berkus 15:16
Re: setting a non-standard date format for the duration of a session Josh Berkus 15:19
Re: SQL challenge--top 10 for each key value? Josh Berkus 15:51
begin update ... syntax error Kemin Zhou 21:32
Re: begin update ... syntax error Gregory S. Williamson 21:51
Re: begin update ... syntax error Adrian Klaver 22:07
Re: SQL challenge--top 10 for each key value? Troels Arvin 22:13
Re: SQL challenge--top 10 for each key value? Troels Arvin 22:17
Re: begin update ... syntax error Yasir Malik 22:19
Re: SQL challenge--top 10 for each key value? elein 23:46

April 11, 2004

Thread Author Time
Re: SQL challenge--top 10 for each key value? elein 01:54
Re: SQL challenge--top 10 for each key value? Greg Stark 04:38
cursors and for loops? Dennis 04:59
trigger/for key help Bret Hughes 05:43
Re: trigger/for key help Stephan Szabo 15:17
Re: cursors and for loops? Tom Lane 16:00
Re: SQL challenge--top 10 for each key value? elein 18:20
Re: cursors and for loops? Dennis 18:46
Re: trigger/for key help Bret Hughes 19:19
Re: trigger/for key help Tom Lane 22:00
Re: trigger/for key help Bret Hughes 22:58

April 12, 2004

Thread Author Time
Re: trigger/for key help Tom Lane 02:27
Re: trigger/for key help Bret Hughes 07:18
Re: Function for numbering rows? CoL 22:21

April 13, 2004

Thread Author Time
Re: trigger/for key help Greg Stark 06:20
Re: cursors and for loops? Richard Huxton 08:31
relation X does not exist Laura Scott 12:49
Re: trigger/for key help Tom Lane 13:25
Formatting Functions and Group By Terry Brick 16:13
Re: Formatting Functions and Group By Bruno Wolff III 16:45
Re: Formatting Functions and Group By Tom Lane 17:33
Re: trigger/for key help Greg Stark 17:36
Re: Formatting Functions and Group By Terry Brick 17:49
Re: SQL challenge--top 10 for each key value? Jeff Boes 18:34
Re: trigger/for key help Tom Lane 18:35
function returning array Dennis 22:41

April 14, 2004

Thread Author Time
Re: function returning array Tom Lane 03:30
Re: function returning array Joe Conway 04:10
Database triggers Charity M 13:57
Re: Help with COPY command Christoph Haller 15:42
Re: Help with COPY command Tony and Bryn Reina 15:54
full join...using and version of pgsql Tina Messmann 17:05
Re: full join...using and version of pgsql scott.marlowe 20:39

April 15, 2004

Thread Author Time
SET idiom in insert statement Kenneth Gonsalves 01:38
type conversions sad 04:04
Grant permission to all objects of user A to user B kumar 06:58
SQL script vickr1z 08:22
Re: SQL script Richard Huxton 09:12
Re: problem porting MySQL SQL to Postgres Reinoud van Leeuwen 09:55
problem porting MySQL SQL to Postgres Dan Field 10:25
Re: problem porting MySQL SQL to Postgres Paul Thomas 11:15
Re: problem porting MySQL SQL to Postgres CoL 11:30
Re: problem porting MySQL SQL to Postgres Martin Marques 11:30
Re: function returning array Dennis 12:16
Re: Database triggers Charles Wilt 13:50
Re: function returning array Dennis 14:03
Re: cursors and for loops? Jan Wieck 14:50
Re: function returning array Joe Conway 16:10
Re: Row count after SELECT INTO? Christoph Haller 16:58
Re: Grant permission to all objects of user A to user B Christoph Haller 17:07
Update is very slow on a bigger table Dimitar Georgievski 21:07
Re: Update is very slow on a bigger table Tom Lane 22:51
Re: Update is very slow on a bigger table CoL 22:53

April 16, 2004

Thread Author Time
Re: Database triggers Charity M 12:32
Re: Update is very slow on a bigger table Dimitar Georgievski 14:40
What is the best way of writing update rule on view with joined tables? Cornelius Grotjahn 17:43
Re: Update is very slow on a bigger table Yudie 17:47
Querying From two databases Pallav Kalva 17:55
Querying two databases Pallav Kalva 18:02
Re: Querying two databases Rajesh Kumar Mallah 18:37
run application from trigger? Yudie 20:21

April 17, 2004

Thread Author Time
ANN: www.SQL-Scripts.Com Greg 05:45
Re: run application from trigger? Richard Huxton 09:37
Re: Update is very slow on a bigger table Bruno Wolff III 15:13

April 18, 2004

Thread Author Time
Concatenate results of a single column query Marco Lazzeri 14:36
Concatenate results of a single column query Marco Lazzeri 15:44
Re: Concatenate results of a single column query Greg Stark 17:42
Re: problem porting MySQL SQL to Postgres Markus Bertheau 18:37
Re: problem porting MySQL SQL to Postgres Paul Thomas 19:24

April 19, 2004

Thread Author Time
Re: problem porting MySQL SQL to Postgres Bruno Wolff III 03:21
three-way join Gary Stainburn 12:47
Re: Concatenate results of a single column query Greg Stark 13:45
Re: three-way join Stijn Vanroye 14:06
Re: three-way join Gary Stainburn 15:01
Re: Concatenate results of a single column query Christoph Haller 15:15
Re: Update is very slow on a bigger table scott.marlowe 15:33
Re: Concatenate results of a single column query CoL 15:47
Prepared Statements and large where-id-in constant blocks? James Robinson 15:56
Re: three-way join - solved Gary Stainburn 16:13
Re: three-way join Bruno Wolff III 17:45
Re: Querying From two databases Bruce Momjian 18:30
Re: [SQL] SQL script scott.marlowe 20:17
Can someone tell me why this statement is failing? P A 20:31
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett 22:21

April 20, 2004

Thread Author Time
Re: [SQL] Prepared Statements and large where-id-in constant blocks? Tom Lane 01:02
Re: relation X does not exist Tom Lane 01:11
Re: Prepared Statements and large where-id-in constant blocks? Oliver Jowett 02:57
Re: three-way join - solved Stijn Vanroye 07:26
Re: Can someone tell me why this statement is failing? Martin Marques 14:40
Re: Can someone tell me why this statement is failing? Edmund Bacon 14:42
Re: Can someone tell me why this statement is failing? Rod Taylor 15:32
Re: Prepared Statements and large where-id-in constant blocks? James Robinson 15:35
transaction H.J. Sanders 19:14
Follow-up: FK constraint performance ow 19:25
Syntax for cmd to EXEC...how many quotes? David B 23:24

April 21, 2004

Thread Author Time
Re: transaction Bruno Wolff III 02:00
staggered query? Vincent Ladlad 02:53
Re: Follow-up: FK constraint performance ow 03:45
Re: staggered query? Denis P Gohel 07:11
Re: transaction denis 07:28
Re: Syntax for cmd to EXEC...how many quotes? denis 08:44
Re: Can someone tell me why this statement is failing? denis 08:53
Re: transaction Andrew Sullivan 10:13
Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 10:30
Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye 10:58
Re: Order by YYYY MM DD in reverse chrono order trouble denis 11:36
Re: Syntax for cmd to EXEC...how many quotes? George Weaver 12:20
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 12:20
datediff script Erik Aronesty 14:13
Trigger calling a function HELP ME! abief_ag_-postgresql 14:43
Re: Order by YYYY MM DD in reverse chrono order trouble Edmund Bacon 14:52
Trigger calling a function HELP ME! (2) Riccardo Facchini 14:54
Which SQL command creates ExclusiveLock? Denis Khabas 14:58
problem with slow select francescosaf 15:00
Trigger calling a function HELP ME! (2) abief_ag_-postgresql 15:16
Server Side C programming Environment Set up Kemin Zhou 17:57
Re: transaction Bruno Wolff III 18:02
Join issue on a maximum value Heflin 18:29
Re: Join issue on a maximum value Bruno Wolff III 18:51
Re: Join issue on a maximum value Jeremy Semeiks 19:12
Re: Join issue on a maximum value Edmund Bacon 19:21
rule's behavior with join interesting Kemin Zhou 20:07
Re: Join issue on a maximum value Heflin 20:28
Proper SQL syntax requested Blake 23:41

April 22, 2004

Thread Author Time
Re: Join issue on a maximum value Bruno Wolff III 01:51
Re: Join issue on a maximum value Tom Lane 03:30
Re: Server Side C programming Environment Set up Peter Eisentraut 05:18
Re: Server Side C programming Environment Set up Tom Lane 05:59
Select from two databases Becky Alcorn 07:00
Re: staggered query? Vincent Ladlad 08:44
Bug#960: WAS: Trigger calling a function HELP ME! (2) abief_ag_-postgresql 09:41
Re: rule's behavior with join interesting Richard Huxton 09:49
Re: Select from two databases Richard Huxton 09:50
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 09:56
Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye 10:47
Re: Trigger calling a function HELP ME! (2) Richard Huxton 11:19
Re: Order by YYYY MM DD in reverse chrono order trouble Tom Lane 13:01
Re: Order by YYYY MM DD in reverse chrono order trouble ogjunk-pgjedan 13:37
Re: Server Side C programming Environment Set up Rod Taylor 13:58
Re: Server Side C programming Environment Set up Peter Eisentraut 14:07
Re: Server Side C programming Environment Set up Peter Eisentraut 14:11
Re: Server Side C programming Environment Set up Rod Taylor 14:21
Design Problem... Ryan Riehle 15:09
Re: Server Side C programming Environment Set up Tom Lane 16:07
Re: Server Side C programming Environment Set up Kemin Zhou 16:09
Re: Server Side C programming Environment Set up Tom Lane 16:13
lifetime of temp schema versus compiled image of plpgsql proc Dennis 19:29
Re: rule's behavior with join interesting Jan Wieck 19:57
Re: staggered query? Federico Pedemonte 20:09
Cascade delete question Glenn MacGregor 21:23
Re: lifetime of temp schema versus compiled image of plpgsql proc Dennis 21:32
Is there an easy way to normalize-space with given string functions Janning Vygen 22:59
Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian 23:46
Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian 23:54

Browse Archives

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