pgsql-sql since 2001-07-18 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

July 18, 2001

Thread Author Time
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Chris Ruprecht 00:01
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) 📎 Josh Berkus 05:35
SPI_exec does not return! Markus Wagner 08:10
Re: CAST(ipaddress as text) -- HOW? Bhuvan A 09:23
Re: SPI_exec does not return! Jan Wieck 10:54
What is the syntax turn off auto commit? 📎 Raymond Chui 12:18
pl/pgsql - code review + question Gary Stainburn 14:10
Re: pl/pgsql - code review + question Richard Huxton 15:03
Re: pl/pgsql - code review + question Gary Stainburn 15:24
RE: pl/pgsql - code review + question Jeff Eckermann 15:46
RE: pl/pgsql - code review + question Jeff Eckermann 15:48
Re: pl/pgsql - code review + question Gary Stainburn 15:56
Re: pl/pgsql - code review + question Richard Huxton 16:24
Re: pl/pgsql - code review + question Tom Lane 16:29
Records exactly the same. Fons Rave 16:37
Re: Records exactly the same. Nils Zonneveld 16:49
Re: [SQL] What is the syntax turn off auto commit? Stephan Szabo 18:18
Re: pl/pgsql - code review + question Tom Lane 20:34
Re: How Postgresql Compares For Some Query Types markir 23:02
Re: pl/pgsql - code review + question Josh Berkus 23:53

July 19, 2001

Thread Author Time
Searching multiple fields from multiple tables A. Mannisto 08:57
Re: pl/pgsql - code review + question Richard Huxton 09:04
Get the tables names? Magnus Landahl 09:04
Re: pl/pgsql - code review + question Richard Huxton 10:09
Query optimizing - paradox behave 📎 David M. Richter 10:20
Re: Query optimizing - paradox behave Stephan Szabo 15:12
Re: pl/pgsql - code review + question 📎 Josh Berkus 15:19
querying values defined in a check constraint danno 15:28
Re: Query optimizing - paradox behave 📎 Josh Berkus 15:31
Re: Get the tables names? Nils Zonneveld 22:51

July 20, 2001

Thread Author Time
nextval on insert by arbitrary sequence Dado Feigenblatt 02:17
Re: nextval on insert by arbitrary sequence 📎 Josh Berkus 03:47
Re: nextval on insert by arbitrary sequence Henry House 07:40
Query optimizing - paradox behave 📎 David M. Richter 08:49
multiple lookup per row Gary Stainburn 09:39
Cast '' (blank) to null date Mattis Jiderhamn 09:44
example of [outer] join Gary Stainburn 10:22
Re: example of [outer] join David Stanaway 11:12
When PostgreSQL compliant JDBC 2.0? 📎 Raymond Chui 13:36
Re: pl/pgsql - code review + question Bruce Momjian 14:22
Re: multiple lookup per row 📎 Josh Berkus 14:41
Re: Records exactly the same. 📎 Josh Berkus 14:47
TODO List Chris Ruprecht 15:21
Re: multiple lookup per row Tom Lane 15:47
Re: Cast '' (blank) to null date Tom Lane 15:58
Re: multiple lookup per row Josh Berkus 15:58
RE: example of [outer] join Jeff Eckermann 16:12
RE: Records exactly the same. Jeff Eckermann 16:23
Re: TODO List Bruce Momjian 16:56
Re: Query optimizing - paradox behave Tom Lane 17:05
Re: nextval on insert by arbitrary sequence Dado Feigenblatt 17:10
Re: nextval on insert by arbitrary sequence Dado Feigenblatt 17:13
Re: Get the tables names? Roberto Mello 18:27
PLpgSQL Dado Feigenblatt 19:26
Re: Get the tables names? Dado Feigenblatt 19:58
Re: nextval on insert by arbitrary sequence Josh Berkus 20:38
Re: TODO List Josh Berkus 20:42
Re: Get the tables names? Joel Burton 20:43
Re: TODO List Chris Ruprecht 20:59
Re: Get the tables names? Tom Lane 21:02
Re: Get the tables names? Magnus Landahl 21:14
RE: PLpgSQL Jeff Eckermann 21:25
Re: PLpgSQL Dado Feigenblatt 23:34

July 21, 2001

Thread Author Time
Re: nextval on insert by arbitrary sequence Dado Feigenblatt 00:04
Re: nextval on insert by arbitrary sequence David Stanaway 04:30
Re: When PostgreSQL compliant JDBC 2.0? Ed Yu 05:50
Re: CAST(ipaddress as text) -- HOW? Bhuvan A 05:58
Re: Records exactly the same. Fons Rave 12:15
Re: Re: PLpgSQL 📎 Josh Berkus 16:30

July 22, 2001

Thread Author Time
unique index on more than one field using functions Domingo Alvarez Duarte 10:14
Re: Get the tables names? D'Arcy J.M. Cain 12:12

July 23, 2001

Thread Author Time
where'd the spaces come from Gary Stainburn 09:18
Re: where'd the spaces come from Gary Stainburn 10:10
Re: where'd the spaces come from Richard Huxton 11:00
Possible problems with cyclic references Gary Stainburn 11:30
Procedures in views Morgan Curley 13:40
What's wrong with this syntax? 📎 Raymond Chui 14:00
Re: Possible problems with cyclic references Jan Wieck 14:18
Re: Possible problems with cyclic references Gary Stainburn 14:26
position(text,text) function Karl Orbell 14:27
Re: Re: PLpgSQL Jan Wieck 14:27
how can we get total records in pg server? Bhuvan A 14:33
RE: Records exactly the same. Jeff Eckermann 15:14
Re: Re: Records exactly the same. 📎 Josh Berkus 15:26
Full-text Indexing and Primary Keys 📎 Josh Berkus 15:32
Re: Re: Records exactly the same. Richard Huxton 15:59
Re: Full-text Indexing and Primary Keys Chris Ruprecht 16:28
Determining if two subnets intersect Florian Weimer 16:56
Re: Full-text Indexing and Primary Keys Giles Lean 17:03
Re: Get the tables names? dado feigenblatt 17:10
Re: unique index on more than one field using functions Stephan Szabo 17:49
Re: position(text,text) function Dorin Grunberg 17:58
Re: position(text,text) function omid omoomi 18:09
Re: [SQL] What's wrong with this syntax? Stephan Szabo 18:19
RE: position(text,text) function Jeff Eckermann 18:36
Re: RE: position(text,text) function Josh Berkus 19:06
Re: Re: Get the tables names? Stephan Szabo 21:56

July 24, 2001

Thread Author Time
Re: Query optimizing - paradox behave 📎 David M. Richter 11:11
Table scan instead of index scan Mário Sérgio G Antunes 13:07
Re: how can we get total records in pg server? Bhuvan A 13:33
Re: Table scan instead of index scan Stephan Szabo 13:34
How to get the server version?? Roberto João Lopes Garcia 13:50
Re: position(text,text) function Karl Orbell 13:53
Re: How to get the server version?? Richard Huxton 14:23
Re: How to get the server version?? omid omoomi 14:24
Re: How to get the server version?? Ross J. Reedstrom 14:37
Re: Query optimizing - paradox behave 📎 David M. Richter 15:24
Re: how can we get total records in pg server? 📎 Josh Berkus 15:30

July 25, 2001

Thread Author Time
Re: Re: When PostgreSQL compliant JDBC 2.0? Tom Lane 00:30
Re: nextval on insert by arbitrary sequence Henry House 05:57
Re: Determining if two subnets intersect Tom Lane 06:49
Inserts in triggers Morgan Curley 07:11
Inserts in triggers Morgan Curley 07:12
Re: Determining if two subnets intersect Florian Weimer 07:17
Re: Inserts in triggers Richard Huxton 08:56
Re: Inserts in triggers Follow Up Morgan Curley 13:09
Re: how can we get total records in pg server? Henshall, Stuart - WCP 13:13
Meta integrity Renato De Giovanni 15:08
Re: Re: Inserts in triggers Follow Up 📎 Josh Berkus 15:14
Re: Meta integrity 📎 Josh Berkus 15:22
Re: Inserts in triggers Tom Lane 15:31
Re: Re: Inserts in triggers Follow Up Tom Lane 15:43
Re: Re: Inserts in triggers Follow Up 📎 Josh Berkus 15:53
Re: Meta integrity Stephan Szabo 16:26
Re: Meta integrity Grigoriy G. Vovk 17:49
about cursor frederic romagna 17:55

July 26, 2001

Thread Author Time
Need help in how to.... Edipo Elder Fernandes de Melo 14:23
Re: [SQL] When PostgreSQL compliant JDBC 2.0? (Batch updates) Barry Lind 16:34
performance issue with distance function Ryan Littrell 20:04
Re: [SQL] Re: When PostgreSQL compliant JDBC 2.0? Bruce Momjian 20:59
Restriction by grouping problem. Jeff Barrett 21:09
Re: performance issue with distance function Jeff Hoffmann 21:20
Re: Restriction by grouping problem. Josh Berkus 21:50
Re: Restriction by grouping problem. Jeff Barrett 22:03

July 27, 2001

Thread Author Time
Re: Re: Restriction by grouping problem. Philip Warner 01:47
Re: Meta integrity Tom Lane 05:20
Re: Re: Restriction by grouping problem. Philip Warner 07:50
nullif BUG??? guard 09:48
Re: nullif BUG??? 📎 Josh Berkus 15:19
Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) Gonzo Rock 18:01
Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) Gonzo Rock 18:02
Database Design Question Gonzo Rock 18:03
Re: Re: D308-E9AF-4C11 : CONFIRM from pgsql-sql (subscribe) Mike Mascari 18:31
RE: Database Design Question Jimmie Fulton 18:33
RE: [SQL] Database Design Question Gonzo Rock 20:21
Re: RE: [SQL] Database Design Question 📎 Ryan Mahoney 20:24
Re: RE: [SQL] Database Design Question Mike Mascari 20:39
Re: Database Design Question James Orr 20:51
RE: Database Design Question Jimmie Fulton 22:29

July 28, 2001

Thread Author Time
Re: Re: Restriction by grouping problem. Josh Berkus 00:19
Re: Re: Restriction by grouping problem. Philip Warner 01:31
Get name of columns in a table María Elena Hernández 01:36
Why does this plpgslq always return 1? John Oakes 03:00
RE: Database Design Question Joel Burton 03:22
Re: Why does this plpgslq always return 1? Stephan Szabo 03:48
Re: Get name of columns in a table Joel Burton 14:31
Who do I make _ not a wildcard? Roy Souther 18:12
Re: Who do I make _ not a wildcard? Stephan Szabo 19:18

July 29, 2001

Thread Author Time
Re: nullif BUG??? Tom Lane 03:15
Re: performance issue with distance function Mark kirkwood 04:30
Re: Re: Restriction by grouping problem. Tom Lane 20:02

July 30, 2001

Thread Author Time
Re: Who do I make _ not a wildcard? Bruce Momjian 03:38
Date Time Functions - ANSI SQL ? Gonzo Rock 04:19
Re: Date Time Functions - ANSI SQL ? Tom Lane 05:39
Re: Re: Inserts in triggers Follow Up Jan Wieck 14:26
Big table - using wrong index - why? Chris Ruprecht 16:20
Re: Big table - using wrong index - why? Joe Conway 16:43
Re: Why does this plpgslq always return 1? Jan Wieck 16:56
Re: Date Time Functions - ANSI SQL ? Gonzo Rock 17:39
plpgsql function return multiple values? John Oakes 17:46
Re: plpgsql function return multiple values? Jan Wieck 18:11
Re: Big table - using wrong index - why? Chris Ruprecht 18:54
Re: Big table - using wrong index - why? Tom Lane 19:20

July 31, 2001

Thread Author Time
Why can't I ......... Mounir Benzid 07:54
union in subselect? Gary Stainburn 14:42
Re: Get name of columns in a table Richard Huxton 14:54
Re: union in subselect? Tom Lane 15:16
Fuzzy matching? 📎 Josh Berkus 16:05
Re: Fuzzy matching? Joe Conway 17:07
RE: Fuzzy matching? Robby Slaughter 17:07
Re: Fuzzy matching? Josh Berkus 17:34
Re: Fuzzy matching? Joe Conway 17:41
Re: Fuzzy matching? Tom Lane 17:44
Re: Fuzzy matching? Bruce Momjian 17:53
Re: Fuzzy matching? Joe Conway 18:06
Re: Fuzzy matching? Bruce Momjian 18:11
Re: Fuzzy matching? Josh Berkus 18:15
Re: Fuzzy matching? Tom Lane 18:48
Re: Fuzzy matching? Tom Lane 20:09
RE: Fuzzy matching? Jeff Eckermann 20:23
Re: Fuzzy matching? Josh Berkus 20:53
Re: Fuzzy matching? Christopher Sawtell 21:31

Aug. 1, 2001

Thread Author Time
Re: Fuzzy matching? 📎 Timothy H. Keitt 02:27
Re: Fuzzy matching? Timothy H. Keitt 02:40
Converting epoch to timestamp? Roberto Mello 06:57
Re: Converting epoch to timestamp? Richard Huxton 08:28
Re: Converting epoch to timestamp? Roberto Mello 13:29
Re: Converting epoch to timestamp? Tom Lane 14:02
Re: When PostgreSQL compliant JDBC 2.0? Gunnar Rønning 14:14
Exclusion List Michael Richards 15:28

Browse Archives

Prev | Next