pgsql-sql since 2002-06-07 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 17 18 19 20 21 22 23 24 25 26 27 28 29 30

June 7, 2002

Thread Author Time
how to reset serials Joseph Syjuco 00:03
Re: how to reset serials Joseph Syjuco 00:51
Re: PL/pgSQL TODO Bruce Momjian 04:19
UPDATE ... FROM vs standard SQL Richard Huxton 10:33
Re: arrays as pgsql function parameters Achilleus Mantzios 11:23
Re: arrays as pgsql function parameters Achilleus Mantzios 13:33
select failure Ian Cass 13:44
Re: arrays as pgsql function parameters Joseph Syjuco 14:08
Re: UPDATE ... FROM vs standard SQL Jan Wieck 14:20
Re: [HACKERS] PostgreSQL on AIX Zeugswetter Andreas SB SD 14:23
Re: PL/pgSQL TODO Josh Berkus 15:14
Re: UPDATE ... FROM vs standard SQL Josh Berkus 15:20
Re: PL/pgSQL TODO Josh Berkus 15:21
Re: PL/pgSQL TODO 📎 Bruce Momjian 15:33
Re: PL/pgSQL TODO Josh Berkus 15:38
Re: arrays as pgsql function parameters Josh Berkus 15:53
Re: PL/pgSQL TODO 📎 Bruce Momjian 15:53
Re: UPDATE ... FROM vs standard SQL Richard Huxton 16:05
Re: UPDATE ... FROM vs standard SQL Stephan Szabo 16:38
Re: PL/pgSQL TODO Jan Wieck 18:10
Re: UPDATE ... FROM vs standard SQL Josh Berkus 18:50
Limiting database size Maurício Sessue Otta 19:11
Re: PL/pgSQL TODO Bruce Momjian 19:55
multiple primary keys and reference Matt 20:00
encryp pass Ricardo Javier Aranibar León 20:23
Re: passing a list to a function and returning a recordset Marie G. Tuite 20:32
Re: Limiting database size Tulio Oliveira 21:06
Re: Limiting database size Josh Berkus 21:42
arrays as pgsql function parameters Joseph Syjuco 23:57

June 8, 2002

Thread Author Time
Re: Indexing timestamps Bruce Momjian 02:48
Re: PostgreSQL on AIX Bruce Momjian 02:51
Re: PostgreSQL on AIX Bruce Momjian 02:51
Re: [HACKERS] PostgreSQL on AIX Bruce Momjian 02:53
Re: Indexing timestamps Stephan Szabo 04:15

June 9, 2002

Thread Author Time
Q: will GROUP BY make use of an index to return tuples early? Gunther Schadow 17:07
Support for distributed queries with semijoins could be possible, if ... Gunther Schadow 17:43
Re: select failure Gunther Schadow 18:10
Re: Q: will GROUP BY make use of an index to return tuples early? Tom Lane 18:57
Re: select failure Ian Cass 18:58
Re: Support for distributed queries with semijoins could be possible, if ... Tom Lane 19:00
Re: select failure Tom Lane 19:28
Re: select failure Gunther Schadow 20:01
Re: select failure Ian Cass 20:13

June 10, 2002

Thread Author Time
Rule to fill in value on column on insert Bradley Kieser 08:25
Re: Rule to fill in value on column on insert Christopher Kings-Lynne 08:44
VIEWs and FOREIGN keys Achilleus Mantzios 12:09
Re: Rule to fill in value on column on insert Tom Lane 13:22
Efficient DELETE Strategies Christoph Haller 13:42
Re: arrays as pgsql function parameters Joseph Syjuco 13:51
Re: Efficient DELETE Strategies Tom Lane 13:56
Re: multiple primary keys and reference Achilleus Mantzios 14:40
Re: multiple primary keys and reference Stephan Szabo 15:58
Re: [SQL] VIEWs and FOREIGN keys Stephan Szabo 16:10
Re: Efficient DELETE Strategies Bruce Momjian 16:48
Re: [SQL] VIEWs and FOREIGN keys Jan Wieck 17:20
Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing 17:33
Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian 18:33
Re: [SQL] VIEWs and FOREIGN keys terry 18:49
Re: [SQL] VIEWs and FOREIGN keys Jan Wieck 19:19
Re: [SQL] VIEWs and FOREIGN keys terry 19:43
Re: Temporary table weirdness Bruce Momjian 19:50
Re: Efficient DELETE Strategies Manfred Koizar 20:23
Re: [HACKERS] Efficient DELETE Strategies Tom Lane 20:34
Re: [SQL] VIEWs and FOREIGN keys Tom Lane 20:38
Re: Efficient DELETE Strategies Tom Lane 21:07
Re: Efficient DELETE Strategies Josh Berkus 22:41
Re: [HACKERS] Efficient DELETE Strategies Dann Corbit 23:08

June 11, 2002

Thread Author Time
Re: [HACKERS] Efficient DELETE Strategies Barry Lind 00:25
Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian 02:53
Re: [HACKERS] Efficient DELETE Strategies Christopher Kings-Lynne 03:18
Re: [SQL] VIEWs and FOREIGN keys Achilleus Mantzios 06:44
Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing 10:02
Re: Efficient DELETE Strategies Christoph Haller 11:18
Re: Efficient DELETE Strategies Tom Lane 14:28
Unicode and escaping single quotes Olaf Frączyk 15:19
inheritance problems Matt 16:19
Select * (but exclude columns) Adam 18:21
How to remove contraint Vernon Wu 19:57
Timestamp problem kumar 20:40
temporary tables Marie G. Tuite 23:07
Domains Andy Pearce 23:31
Re: temporary tables Bruce Momjian 23:33
make a unique index for foreign keys? Beth Gatewood 23:48

June 12, 2002

Thread Author Time
Re: make a unique index for foreign keys? Josh Berkus 00:24
Re: Unicode and escaping single quotes Tatsuo Ishii 06:01
Re: Unicode and escaping single quotes Olaf Frączyk 07:28
General trigger function GRIMOIS Eric 07:48
Re: Efficient DELETE Strategies Manfred Koizar 14:03
Re: Efficient DELETE Strategies Tom Lane 14:49
Re: Timestamp problem Stephan Szabo 14:57
Re: Efficient DELETE Strategies Bruce Momjian 16:36
Re: Domains Bruce Momjian 17:52
Re: Efficient DELETE Strategies Manfred Koizar 18:06
Re: General trigger function Jan Wieck 20:32
Re: make a unique index for foreign keys? Josh Berkus 23:34
Re: make a unique index for foreign keys? Beth Gatewood 23:44

June 13, 2002

Thread Author Time
Case insensitive select isaac flemmin 00:43
Re: Case insensitive select Josh Berkus 01:08
Re: Case insensitive select isaac flemmin 01:27
Re: Case insensitive select Stephan Szabo 01:34
Re: make a unique index for foreign keys? Christopher Kings-Lynne 01:53
Re: Case insensitive select isaac flemmin 02:06
Re: Case insensitive select Josh Berkus 04:35
Please help me out on this insert error Vernon Wu 05:16
Re: How to remove contraint Christopher Kings-Lynne 05:29
Re: Please help me out on this insert error Vernon Wu 07:24
Re: Please help me out on this insert error Vernon Wu 07:50
Re: General trigger function Richard Huxton 08:50
Rule problem Svenn Helge Grindhaug 10:11
How to unsubscribe? SDX 10:51
Another postgres 'file not found' error Ian Cass 11:17
Re: Another postgres 'file not found' error Achilleus Mantzios 13:19
join question - three tables, two with foreign keys to the first Dmitri Colebatch 14:13
Re: join question - three tables, two with foreign keys to the first Dmitri Colebatch 14:32
Re: Rule problem Tom Lane 14:36
Re: join question - three tables, two with foreign keys to the first Manfred Koizar 15:19
Re: join question - three tables, two with foreign keys to Stephan Szabo 15:21
how do i provide array parameters for my functions in php joseph 15:59
Re: Another postgres 'file not found' error Josh Berkus 16:06
Re: Another postgres 'file not found' error Ian Cass 16:16
Re: make a unique index for foreign keys? Beth Gatewood 16:23
Re: how do i provide array parameters for my functions in php Achilleus Mantzios 16:30
Re: make a unique index for foreign keys? Jan Wieck 16:59
Re: Another postgres 'file not found' error Josh Berkus 18:01
Isn't there a better way? Josh Berkus 19:41
serial column vs. explicit sequence question Charlie Toohey 20:03
Re: Another postgres 'file not found' error Tom Lane 20:07
Re: serial column vs. explicit sequence question Josh Berkus 21:04
Re: serial column vs. explicit sequence question Stephan Szabo 21:06
Re: serial column vs. explicit sequence question Tom Lane 21:13
Re: Another postgres 'file not found' error Oliver Elphick 21:30
Re: Please help me out on this insert error Joe Conway 21:53
Re: serial column vs. explicit sequence question Jason Earl 22:01
Re: serial column vs. explicit sequence question Charlie Toohey 22:09
Re: Please help me out on this insert error Stephan Szabo 22:12
Re: serial column vs. explicit sequence question Stephan Szabo 22:13
Re: serial column vs. explicit sequence question Charlie Toohey 22:15
Re: Please help me out on this insert error Manfred Koizar 22:26
Re: Please help me out on this insert error Stephan Szabo 22:31
Re: join question - three tables, two with foreign keys to the first Dmitri Colebatch 22:38
simple recursive function in plpgsql fails Andrew Hammond 23:39

June 14, 2002

Thread Author Time
Re: join question - requesting for a simple C program where it can INSERT data into database as reference joo 02:03
Re: make a unique index for foreign keys? Christopher Kings-Lynne 02:24
Re: simple recursive function in plpgsql fails Tom Lane 05:02
function not running after upgrade from 7.03 to 7.2 juerg.rietmann 08:08
Function not running after upgrade 7.03 to 7.2 juerg.rietmann 08:11
Re: Function not running after upgrade 7.03 to 7.2 Christopher Kings-Lynne 08:20
ON DELETE CASCADE question Wei Weng 13:40
Re: ON DELETE CASCADE question Josh Berkus 16:05
Re: ON DELETE CASCADE question Jan Wieck 17:14
inheritance problems Matt 17:38
check Matt 18:47
Re: function not running after upgrade from 7.03 to 7.2 Jan Wieck 19:27
Re: inheritance problems Stephan Szabo 20:03

June 17, 2002

Thread Author Time
template1 - recreate Rudi Starcevic 06:17
join question - requesting for a simple C program where it can INSERT data into database as reference Christoph Haller 13:46
Re: check Christopher Kings-Lynne 14:40
Re: check Stephan Szabo 14:55
Re: check Manfred Koizar 16:35
Re: Limiting database size Jeff Boes 16:52
Re: template1 - recreate Josh Berkus 18:47
Request for builtin function: Double_quote Josh Berkus 20:34
Users Andy Pearce 23:46

June 18, 2002

Thread Author Time
Re: Limiting database size Ulrich Sprick 08:11
Re: Request for builtin function: Double_quote Christoph Haller 09:35
function text_ge(text, text), how to use on version 7.2 juerg.rietmann 12:08
Re: function text_ge(text, text), how to use on version 7.2 Achilleus Mantzios 13:24
Re: Request for builtin function: Double_quote Tom Lane 14:48
Re: Request for builtin function: Double_quote Josh Berkus 15:49
Re: Users Bruno Wolff III 16:02
text vs varchar Wei Weng 22:07
Re: text vs varchar Josh Berkus 22:59
date_part Rudi Starcevic 23:19
Re: text vs varchar Michelle Murrain 23:31
Re: text vs varchar Wei Weng 23:49

June 19, 2002

Thread Author Time
is it easy to change the create sequence algorithm? Kevin Brannen 00:16
Re: date_part Josh Berkus 00:47
Re: text vs varchar Josh Goldberg 01:28
Help with a "recursive" query Jerome Alet 07:30
Re: text vs varchar Achilleus Mantzios 07:44
Aggregates not allowed in WHERE clause? Joachim Trinkwitz 08:04
Re: Aggregates not allowed in WHERE clause? Christopher Kings-Lynne 08:13
Re: Aggregates not allowed in WHERE clause? Achilleus Mantzios 08:18
Re: Help with a "recursive" query Oleg Bartunov 08:41
Re: Aggregates not allowed in WHERE clause? Christoph Haller 10:18
Joining three data sources. Janning Vygen 10:33
Mirar y reenviar por favor!!! son 2 segundos Marta Beatriz Caldentey 11:05
SQL performance issue with PostgreSQL compared to MySQL Jeff Self 13:26
Re: Joining three data sources. Masaru Sugawara 14:09
Re: SQL performance issue with PostgreSQL compared to MySQL Tom Lane 14:18
Re: SQL performance issue with PostgreSQL compared to Josh Berkus 14:58
Tagging rows into collections? Steve Wampler 16:02
Re: SQL performance issue with PostgreSQL compared to MySQL Bruce Momjian 16:43
syntax for access an alias in the where clause ? Michael Agbaglo 18:03
Re: Joining three data sources. Janning Vygen 18:07
Which one is faster? Wei Weng 19:27
Re: syntax for access an alias in the where clause ? Wei Weng 19:56
Re: Which one is faster? Bruce Momjian 20:34
Assign values to array afa 20:45
Re: syntax for access an alias in the where clause ? Michael Agbaglo 21:13

Browse Archives

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