pgsql-sql since 2001-07-13 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

July 13, 2001

Thread Author Time
How can we match a condition among 2 diff. tables? bhuvansql 06:11
Re: Referencing a view? Grigoriy G. Vovk 07:33
Executing RECORD's inside a FUNCTION Luis Sousa 09:20
No subselects in constraint (bug?) Alexey V. Neyman 10:16
Re: Referencing a view? James Orr 13:41
Re: Referencing a view? Grigoriy G. Vovk 15:12
Re: Referencing a view? 📎 Josh Berkus 15:14
Date Validation? 📎 Josh Berkus 15:24
Re: How can we match a condition among 2 diff. tables? Stephan Szabo 15:43
Re: How can we match a condition among 2 diff. tables? Peter Eisentraut 16:18
using custom column names in a group by clause Matt Rinkenberger 16:33
Re: Date Validation? Stephan Szabo 16:39
Re: How can we match a condition among 2 diff. tables? Andre Schnabel 16:41
Re: Date Validation? Richard Huxton 17:04
You have an error in your SQL syntax near '' at line 1 Ari Nepon 17:38
Re: Date Validation? Josh Berkus 17:44
Re: No subselects in constraint (bug?) Stephan Szabo 18:25
Re: How can we match a condition among 2 diff. tables? Joe Conway 18:57
Re: No subselects in constraint (bug?) Tom Lane 19:00
Re: You have an error in your SQL syntax near '' at line 1 Josh Berkus 19:01

July 14, 2001

Thread Author Time
Re: Date Validation? dev 15:29
Re: Date Validation? 📎 Josh Berkus 18:40
Help with SQL statement - Thanks Henry 19:16
Re: Help with SQL statement - Thanks Tom Moreau 22:26

July 15, 2001

Thread Author Time
Re: Date Validation? 📎 Christopher Sawtell 03:43
Hey! ORDER BY in VIEWS? 📎 Josh Berkus 17:21
RE: Hey! ORDER BY in VIEWS? Robby Slaughter 18:32
Re: Hey! ORDER BY in VIEWS? Bruce Momjian 18:45
Re: Hey! ORDER BY in VIEWS? Peter Eisentraut 19:30
Re: Hey! ORDER BY in VIEWS? Josh Berkus 19:41
RE: Hey! ORDER BY in VIEWS? Robby Slaughter 20:02
ANNOUNCE: Updated PostgreSQL Notes Richard Huxton 20:58
Re: Hey! ORDER BY in VIEWS? Tom Lane 21:14
Re: Hey! ORDER BY in VIEWS? Josh Berkus 21:40
Re: Hey! ORDER BY in VIEWS? Tom Lane 21:50

July 16, 2001

Thread Author Time
Unknown values in int8 fields? Chris Ruprecht 02:05
RE: Unknown values in int8 fields? Robby Slaughter 02:24
Re: Unknown values in int8 fields? Stephan Szabo 03:48
Re: Hey! ORDER BY in VIEWS? Richard Huxton 06:38
SELECT * from select - HOW? Bhuvan A 08:57
SELECT * FROM select -- got it! Bhuvan A 09:13
is it possible to comment each column of a table? Bhuvan A 10:19
interpreting attributes in pg_class Markus Wagner 10:57
Re: Hey! ORDER BY in VIEWS? Bruce Momjian 14:40
Re: Help with SQL statement - Thanks James Orr 18:31
Re: interpreting attributes in pg_class Peter Eisentraut 20:52

July 17, 2001

Thread Author Time
ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found Dado Feigenblatt 02:46
Re: ERROR: UNIQUE constraint matching given keys for referenced table "sequences" not found Richard Huxton 08:37
RE: Re: drop table if exists Maxim Maletsky 10:16
Re: Performance tuning in PostgreSQL? Edipo Elder Fernandes de Melo 11:56
Re: Select distinct and order by. Tod McQuillin 13:25
First steps in plpgsql - language not recognized? Chris Ruprecht 13:48
CAST(ipaddress as text) -- HOW? Bhuvan A 14:05
RE: First steps in plpgsql - language not recognized? Robby Slaughter 15:02
Re: How Postgresql Compares For Some Query Types 📎 Josh Berkus 15:18
Re: First steps in plpgsql - language not recognized? Peter Eisentraut 15:25
Re: Select distinct and order by. Tom Lane 16:00
Re: [SQL] epoch to show millseconds Tom Lane 16:04
Fw: Query Optimisation required Kapil Tilwani 16:14
Building RPMS with plperl (solution) Zot O'Connor 18:25
Re: using custom column names in a group by clause Josh Berkus 18:37
PL/PGSQL and external (flat ASCII) files - Urgent ... :) Chris Ruprecht 20:28
RE: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Robby Slaughter 20:38
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Tom Lane 21:06
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Peter Eisentraut 21:08
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Wei Weng 21:59
Re: [SQL] epoch to show millseconds Grant 22:33
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Chris Ruprecht 22:45
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Tom Lane 23:19
Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) Josh Berkus 23:31

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

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