pgsql-sql since 2004-03-28 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

March 28, 2004

Thread Author Time
Re: Slow sub-selects, max and count(*) Greg Stark 06:31

March 29, 2004

Thread Author Time
Re: date_part stored procs Tsoloane Moahloli 07:30
Re: Invalid Unicode Character Sequence found Bulatovic Natasa 07:33
Question on pgsql trigger Jon Poulton 17:12
Re: Slow sub-selects, max and count(*) Josh Berkus 21:47

March 30, 2004

Thread Author Time
Entered data appears TWICE in table!!? Ron M. 19:29
plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 22:08

March 31, 2004

Thread Author Time
SQL Spec Compliance Questions Josh Berkus 04:50
Re: [SQL] SQL Spec Compliance Questions Tom Lane 05:18
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 06:14
Re: plpgsql vs. SQL in stored procedures Christopher Browne 08:31
Timestamp manipulation Stephen Quinney 10:41
Re: plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 11:07
Re: plpgsql vs. SQL in stored procedures Richard Huxton 12:06
Is it normal that functions are so much faster than inline queries Olivier Hubaut 12:28
Re: Is it normal that functions are so much faster than inline queries Tom Lane 15:33
Simple insert not returning Kyle 18:06
left join on a view takes significantly more time. Manuel Sugawara 18:55
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 22:41
Re: left join on a view takes significantly more time. Josh Berkus 23:49

April 1, 2004

Thread Author Time
Re: Is it normal that functions are so much faster than inline queries Olivier Hubaut 07:07
Re: DB question - Merging data from one table to another. malia, sean 15:27
Getting the ranks of results from a query abhi 16:05
Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:20
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:36
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:48
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:51
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:57

April 2, 2004

Thread Author Time
Re: SQL Spec Compliance Questions Joe Conway 07:03
Re: SQL Spec Compliance Questions Josh Berkus 16:38
Re: SQL Spec Compliance Questions Joe Conway 16:48
Re: SQL Spec Compliance Questions Josh Berkus 16:53
Re: [SQL] SQL Spec Compliance Questions Tom Lane 17:47

April 3, 2004

Thread Author Time
Re: order of results Gregor Rot 15:08
Re: SQL Spec Compliance Questions Peter Eisentraut 23:24
Re: [SQL] SQL Spec Compliance Questions Peter Eisentraut 23:26

April 5, 2004

Thread Author Time
oracle varray functionality? Postgres User 15:45
Function To Log Changes Gavin 17:01
Re: Function To Log Changes Josh Berkus 17:18
Re: Function To Log Changes Tom Lane 17:39
group by not returning sorted rows Bret Hughes 21:55
Re: Entered data appears TWICE in table!!? Jeff Eckermann 22:33
Re: group by not returning sorted rows Tom Lane 22:34
Re: Question on pgsql trigger Jeff Eckermann 22:34
Re: group by not returning sorted rows Stephan Szabo 22:54
Re: DB question - Merging data from one table to another. scott.marlowe 22:55

April 6, 2004

Thread Author Time
Re: Rename Schema or Script DDL only a schema Olivier Hubaut 08:17
Rename Schema or Script DDL only a schema kumar 09:02
could not devise a query plan SZŰCS Gábor 13:12
Re: Entered data appears TWICE in table!!? Jeff Eckermann 14:27
partial unique constraint Robert Treat 14:29
Re: could not devise a query plan Tom Lane 15:00
Re: partial unique constraint Stephan Szabo 15:05
Re: partial unique constraint ries 15:05
Re: partial unique constraint Tom Lane 15:17
Re: partial unique constraint Rod Taylor 15:17
Re: partial unique constraint Achilleus Mantzios 15:18
Re: partial unique constraint Paul Thomas 15:26
Re: partial unique constraint Robert Treat 16:38
Re: group by not returning sorted rows Bret Hughes 16:51
distinct values without seq scan Bret Hughes 17:06
SQL Standatd Ricardo Vaz Mannrich 18:21
Re: SQL Standatd Bruce Momjian 19:01
Re: could not devise a query plan Tom Lane 19:05
Re: Function To Log Changes elein 19:06
Re: partial unique constraint Richard Huxton 19:54
Help with COPY command Tony Reina 20:31

April 7, 2004

Thread Author Time
Re: Getting the ranks of results from a query Bruno Wolff III 04:29
Re: order of results Bruno Wolff III 05:33
Re: Unknown Exception ([email protected]) ?? 07:38
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

Browse Archives

Prev | Next