pgsql-sql since 2003-03-14 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 31

March 14, 2003

Thread Author Time
Poor performance on a right join Carmen 00:12
Re: massive INSERT Greg Stark 00:20
date and plpgsql error Christopher Smith 01:37
Re: date and plpgsql error Stephan Szabo 01:55
displaying correct name Bruce Young 03:11
Re: nearest match Larry Rosenman 05:18
Re: displaying correct name Tomasz Myrta 07:56
Re: Poor performance on a right join dev 08:13
parse error when calling function in plpgsql David Witham 09:18
Re: What's wrong with this group by clause? Manfred Koizar 10:38
Re: View - Join based on dis-similar data types Richard Huxton 10:52
Re: Deleting large object from table pg_largeobject Richard Huxton 11:02
Re: Poor performance on a right join Carmen Sarlo 14:15
Re: Create function statement with insert statement Susan Hoddinott 14:28
Re: Create function statement with insert statement Susan Hoddinott 14:52
Re: Create function statement with insert statement Andreas Schmitz 14:52
Re: Create function statement with insert statement Christoph Haller 15:05
look for latest user login in one table from a list of users in a nother Sill-II, Stephen 16:35
Re: look for latest user login in one table from a list of users Jean-Luc Lachance 17:13
Re: look for latest user login in one table from a list of Sill-II, Stephen 17:15
Re: Create function statement with insert statement Susan Hoddinott 18:54
Re: Create function statement with insert statement Susan Hoddinott 18:58
Re: Create function statement with insert statement Joe Conway 19:37
MapInfo and PostgreSQL how-to David Delorme 20:06
Re: look for latest user login in one table from a list of Achilleus Mantzios 21:14
Re: Function calling error in postgreSQL 7.3.1 CoL 22:49

March 15, 2003

Thread Author Time
Re: SERIAL does not ROLLBACK Andrew McMillan 07:57
create index right after create table not working? joost witteveen 09:16
help with table constraint / check cliff 15:38
Re: help with table constraint / check Bruno Wolff III 16:29
create index right after create table not working? Joost Witteveen 23:53

March 16, 2003

Thread Author Time
Re: two dates D.Sanchez 22:37

March 17, 2003

Thread Author Time
String aggregate function Objectz 08:01
Re: create index right after create table not working? Manfred Koizar 08:08
How to compare dates? Abdul Wahab Dahalan 08:29
Re: How to compare dates? Victor Yegorov 08:45
Re: How to compare dates? Christoph Haller 08:58
Re: String aggregate function Tomasz Myrta 09:16
Re: String aggregate function Objectz 10:35
Re: String aggregate function Tomasz Myrta 10:55
Re: String aggregate function Tomasz Myrta 10:59
Re: Create function statement with insert statement Christoph Haller 11:25
Formatting intervals.. Rajesh Kumar Mallah 11:47
Re: Formatting intervals.. Tomasz Myrta 11:56
Re: Formatting intervals.. Christoph Haller 13:03
Re: Formatting intervals.. Rajesh Kumar Mallah 13:04
Howto?? J.C.M. van der Kwast 13:34
Re: Formatting intervals.. Rajesh Kumar Mallah 14:02
Re: Formatting intervals.. Christoph Haller 14:09
Re: Formatting intervals.. Tomasz Myrta 14:15
Re: String aggregate function Objectz 14:25
Re: Formatting intervals.. Christoph Haller 14:26
Re: Formatting intervals.. Tomasz Myrta 14:32
Re: How to compare dates? Achilleus Mantzios 14:41
Re: Formatting intervals.. Rajesh Kumar Mallah 14:54
Min values? J.C.M. van der Kwast 16:48
howto? Sjors 17:09
Re: howto? Bruno Wolff III 17:53
Re: Formatting intervals.. Josh Berkus 18:00
Re: Formatting intervals.. Larry Rosenman 18:02
Re: Howto?? chester c young 18:57
Re: Howto?? Tomasz Myrta 19:06
Re: parse error when calling function in plpgsql Tom Lane 19:48
Re: btree_gist, gint4_union Bruce Momjian 19:59
upcasting multiplication in a query John Guthrie 20:21
Re: Poor performance on a right join Tom Lane 20:30
Re: Poor performance on a right join dev 20:33
Re: Poor performance on a right join Carmen Sarlo 20:34
Re: upcasting multiplication in a query dev 20:35
Re: btree_gist, gint4_union Tom Lane 20:50
Re: upcasting multiplication in a query Tom Lane 20:51
Re: btree_gist, gint4_union Itai Zukerman 21:06

March 18, 2003

Thread Author Time
Re: Create function statement with insert statement Susan Hoddinott 02:01
Count equals 0 Rudi Starcevic 06:29
PLPGSQL with Multibyte Issue Frankie Lam 07:24
Re: Formatting intervals.. Karel Zak 07:44
Re: PLPGSQL with Multibyte Issue Tatsuo Ishii 07:49
Re: PLPGSQL with Multibyte Issue Frankie Lam 08:35
Re: PLPGSQL with Multibyte Issue Tatsuo Ishii 08:37
the best way to get some records not in another table jack 11:17
Re: Min values? Christoph Haller 11:36
Re: Count equals 0 jasiek 11:37
Trigger issue, bug? on 7.2.1 Miguel Carvalho 13:46
Re: the best way to get some records not in another table Christoph Haller 13:47
Trigger issue, bug? on 7.2.1 Miguel Carvalho 14:15
Re: Trigger issue, bug? on 7.2.1 Tom Lane 14:34
trouble with query alexj 14:47
Numeric type Alan Roberto Romaniuc 15:24
Re: Count equals 0 greg 15:31
Re: Trigger issue, bug? on 7.2.1 Christoph Haller 15:44
Re: Count equals 0 Josh Berkus 16:35
outer join versus not exists chester c young 16:54
Re: Numeric type Tom Lane 17:14
Re: outer join versus not exists Tom Lane 17:29
Re: outer join versus not exists Bruno Wolff III 17:30
showing records from the last 20 min Matthew Nuzum 18:00
Re: showing records from the last 20 min Tomasz Myrta 18:19
Re: showing records from the last 20 min Matthew Nuzum 18:36
Re: Convert a text list to text array? Was: Denormalizing during Guy Fraser 18:55

March 19, 2003

Thread Author Time
Number of rows affected by an update David Witham 04:42
Re: showing records from the last 20 min Rajesh Kumar Mallah 04:59
Casting with character and character varying David Loh 05:43
Re: Number of rows affected by an update Tomasz Myrta 08:12
vacuum all but system tables Victor Yegorov 08:38
Re: Casting with character and character varying Christoph Haller 10:01
Listing Users Kyle 12:19
Re: howto/min values Sjors 13:27
Re: vacuum all but system tables A.Bhuvaneswaran 13:32
Re: howto/min values Christoph Haller 13:54
Re: vacuum all but system tables Tom Lane 14:29
Re: vacuum all but system tables Victor Yegorov 14:39
Re: vacuum all but system tables Tom Lane 14:47
Re: vacuum all but system tables Tomasz Myrta 14:53
Re: Casting with character and character varying Jeff Eckermann 14:59
Re: vacuum all but system tables Victor Yegorov 15:02
Re: howto/min values Sjors 15:07
integrity of column used to order rows cliff 16:18
Re: Listing Users Achilleus Mantzios 16:38
Re: integrity of column used to order rows Ed L. 16:50
Re: trouble with query jasiek 18:49
SQL Sethi Tarun-ETS017 20:52

March 20, 2003

Thread Author Time
Re: the best way to get some records not in another table jack 01:20
query 2 database betty 03:07
Is it possible to select encoding in PLPGSQL function? Frankie Lam 04:35
Re: Count equals 0 Rudi Starcevic 05:38
Re: vacuum all but system tables Tomasz Myrta 08:33
Re: query 2 database Olleg Samojlov 11:32
Re: query 2 database A.Bhuvaneswaran 11:52
SQL stored proc query (optimising) paul_smith1 12:46
Re: Trigger issue, bug? on 7.2.1 Miguel Carvalho 12:55
Rule for updating through a view. Mike Meyer 13:52
Re: SQL stored proc query (optimising) Tom Lane 15:08
Help with LIKE David Olbersen 21:41
Re: Help with LIKE Josh Berkus 21:55
FUNCTIONS PROBLEM Mario Alberto Soto Cordones 22:25
Re: Help with LIKE David Olbersen 23:19

March 21, 2003

Thread Author Time
What this parser mean? Abdul Wahab Dahalan 02:47
Re: What this parser mean? David Witham 02:52
newline character in SQL Sethi Tarun-ETS017 03:16
explain Popeanga Marian 05:46
Re: explain Popeanga Marian 06:09
Re: explain Popeanga Marian 06:21
Re: explain Roberto Mello 06:34
Re: explain Rajesh Kumar Mallah 08:23
Re: explain Popeanga Marian 08:27
Cant get all records from dbase Abdul Wahab Dahalan 08:28
Re: Formatting intervals.. Peter Eisentraut 10:05
Re: Formatting intervals.. Karel Zak 10:30
Re: explain Popeanga Marian 11:00
Re: explain Rajesh Kumar Mallah 12:10
Re: explain Popeanga Marian 12:35
Re: explain A.Bhuvaneswaran 13:08
cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen 13:36
Re: cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen 14:19
Re: cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen 15:01
Re: cast of integer to bool doesn't work (anymore?) Tom Lane 15:07
Seeking help with a query.... Dan Winslow 15:51
Re: explain mallah 16:32
Diffcult query Dan Winslow 17:41
Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios 17:54
Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios 18:46
[No subject] Mario Alberto Soto Cordones 18:50
Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios 19:20
Re: Diffcult query Josh Berkus 19:45
Re: Stephan Szabo 20:13
column label Ryan 20:55
function prepared plan Franco Bruno Borghesi 22:10
Re: Diffcult query Josh Berkus 23:17

March 22, 2003

Thread Author Time
Re: Diffcult query Lee Harr 03:59
Re: explain Popeanga Marian 06:11
SQL help for efficient time handling.. Rajesh Kumar Mallah 08:02
Re: explain Rajesh Kumar Mallah 08:45
Re: SQL help for efficient time handling.. Popeanga Marian 08:45
Re: SQL help for efficient time handling.. Rajesh Kumar Mallah 08:55
Re: SQL help for efficient time handling.. Popeanga Marian 09:08
Re: Diffcult query Harald Fuchs 09:52
Re: newline character in SQL Rajesh Kumar Mallah 10:03
ALTER TABLE does not raises WARNING/ERROR Rajesh Kumar Mallah 11:57
Re: ALTER TABLE does not raises WARNING/ERROR Stephan Szabo 16:09
Re: ALTER TABLE does not raises WARNING/ERROR Tom Lane 16:10
Re: SQL help for efficient time handling.. Stephan Szabo 16:17
Re: newline character in SQL Sethi Tarun-ETS017 16:26
Re: SQL help for efficient time handling.. mallah 17:47
Re: ALTER TABLE does not raises WARNING/ERROR mallah 17:49
Re: newline character in SQL mallah 18:30

March 23, 2003

Thread Author Time
Re: FUNCTIONS PROBLEM David Witham 23:18

March 24, 2003

Thread Author Time
Re: FUNCTIONS PROBLEM Rajesh Kumar Mallah 04:43
Which Approach Performs Better? CN 08:17
Re: Seeking help with a query.... Victor Yegorov 08:20
Re: column label Tomasz Myrta 09:33
function with security definer Tomasz Myrta 09:54
Complex outer joins? Correia, Carla 10:23
Re: Complex outer joins? Peter Childs 10:43
Complex outer joins? Correia, Carla 10:49
Re: Complex outer joins? Correia, Carla 10:56
Re: query 2 database Christoph Haller 10:57
Re: function with security definer Tomasz Myrta 11:16
Re: Seeking help with a query.... Christoph Haller 14:22
UPDATE FROM portability Andreas Pflug 14:30
Re: function with security definer Tom Lane 15:02

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 31