pgsql-sql before 2003-03-01 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

Feb. 20, 2003

Thread Author Time
Re: problem on truncate for v.7.3.2 Josh Berkus 06:14
Re: EXCEPT Queries Josh Berkus 06:45
Re: EXCEPT Queries Peter Childs 08:29
Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson 10:09
Re: once again, sorting with Unicode Troy 10:45
Re: once again, sorting with Unicode Troy 10:51
Re: VIEW or Stored Proc - Is this even possible? Richard Huxton 11:08
pg_func problem Graham Vickrage 12:58
Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson 13:45
Re: point <-> polygon not supported? Tomasz Myrta 14:55
Re: problem on truncate for v.7.3.2 Tom Lane 15:13
How to drop all the sequences Arunachalam Jaisankar 16:40
Re: point <-> polygon not supported? Scott Ding 16:44
Re: point <-> polygon not supported? Tomasz Myrta 17:05
Re: point <-> polygon not supported? Scott Ding 18:34
Re: PL/PGSQL EDITOR Josh Berkus 19:20
Re: How to drop all the sequences Tomasz Myrta 20:39
Re: EXCEPT Queries Jeff Boes 20:59

Feb. 21, 2003

Thread Author Time
Nth Select Mark Mitchell 00:19
Fw: 向华东 03:35
Fw: 向华东 03:35
Re: How to make sequence skip existing key in table? Raymond Pau 06:29
Re: How to drop all the sequences Oleg Samoylov 08:04
Re: Fw: Tomasz Myrta 08:12
Re: Fw: Daniel Schuchardt 11:38
Re: " Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah 13:08
How do I view triggers Graham Vickrage 13:24
good style? Rafal Kedziorski 13:30
Re: good style? Rajesh Kumar Mallah 13:51
Re: good style? Alan Gutierrez 13:54
function defination help .. Rajesh Kumar Mallah 13:54
Re: good style? Tambet Matiisen 14:39
Re: good style? Rafal Kedziorski 16:05
7.3 "group by" issue Dan Langille 18:01
Re: 7.3 "group by" issue Gaetano Mendola 18:18
Re: 7.3 "group by" issue Dan Langille 18:25
Re: 7.3 "group by" issue Chad Thompson 20:00
Re: 7.3 "group by" issue Dan Langille 20:22
Re: 7.3 "group by" issue Chad Thompson 20:30
Re: How do I view triggers Chad Thompson 20:44
Re: 7.3 "group by" issue Dan Langille 20:45
Re: 7.3 "group by" issue Chad Thompson 20:51
join gone awry Matthew Nuzum 22:33
Users and groups Teddy 22:37
Re: 7.3 "group by" issue Josh Berkus 23:25

Feb. 22, 2003

Thread Author Time
Re: 7.3 "group by" issue Dan Langille 00:13
7.3 GROUP BY differs from 7.2 Dan Langille 01:18
Re: 7.3 "group by" issue Peter Eisentraut 02:09
Re: function defination help .. Peter Eisentraut 02:10
Re: 7.3 GROUP BY differs from 7.2 Tom Lane 03:28
Re: function defination help .. Rajesh Kumar Mallah 06:13
Re: [SQL] 7.3 GROUP BY differs from 7.2 Stephan Szabo 07:57
Re: [SQL] 7.3 GROUP BY differs from 7.2 Tom Lane 08:05
SORT with accents Edipo E. F. Melo 11:01
Re: [SQL] 7.3 GROUP BY differs from 7.2 Stephan Szabo 17:41
Re: 7.3 "group by" issue Josh Berkus 19:34

Feb. 23, 2003

Thread Author Time
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 00:14
sql question after upgrade James Cooper 00:58
Re: sql question after upgrade Neil Conway 01:42
Re: 7.3 "group by" issue Peter Eisentraut 02:24
Re: sql question after upgrade Peter Eisentraut 02:24
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 10:47
Porting from db2 problem Wayne Armstrong 11:11
Re: how to return ONE single record from a function in plpgsql? Tom Lane 16:34
Help with query involving aggregation and joining. Eddie Cheung 19:02
Re: inserting multiple rows with one statement codeWarrior 19:26
Re: 7.3 "group by" issue Josh Berkus 19:59
Re: [SQL] 7.3 GROUP BY differs from 7.2 Josh Berkus 20:19
Re: Help with query involving aggregation and joining. Josh Berkus 20:24
Re: Help with query involving aggregation and joining. Bruno Wolff III 20:45
syntax question James Cooper 22:07
SQL Statements question, why I get errors... plist 22:17
Re: syntax question Josh Berkus 22:52
Re: SQL Statements question, why I get errors... Josh Berkus 22:57
Re: syntax question Josh Berkus 23:07
Re: SQL Statements question, why I get errors... plist 23:13
Re: good style? Rafal Kedziorski 23:51

Feb. 24, 2003

Thread Author Time
Re: syntax question Josh Berkus 00:25
Re: SQL Statements question, why I get errors... Bruno Wolff III 03:27
Re: Help with query involving aggregation and joining. Eddie Cheung 05:17
Re: Help with query involving aggregation and joining. Eddie Cheung 05:18
Re: Help with query involving aggregation and joining. Josh Berkus 06:46
Re: Porting from db2 problem Christoph Haller 09:30
Re: Help with query involving aggregation and joining. Rajesh Kumar Mallah 13:24
Re: Help with query involving aggregation and joining. Christoph Haller 13:49
Re: syntax question Jeff Eckermann 15:17
Re: syntax question Tom Lane 15:30
Re: Help with query involving aggregation and joining. mallah 15:51
Re: Help with query involving aggregation and joining. Bruno Wolff III 17:16
Denormalizing during select no.spam 17:18
Dynamic SELECT condition Victor Yegorov 17:53
Re: syntax question Josh Berkus 18:22
Re: Denormalizing during select Jeff Boes 19:12
indexing James Cooper 20:38
Re: Denormalizing during select Josh Berkus 22:33
indexing James Cooper 22:38
Problem with deferred referential integrity checks Bob Smith 23:38

Feb. 25, 2003

Thread Author Time
Inquiry From Form [pgsql] Jack Kiss 00:22
Re: indexing Josh Berkus 01:16
Re: Denormalizing during select no.spam 03:37
Re: Denormalizing during select Edmund Lian 03:44
Sub Select inside Check ? Rudi Starcevic 05:48
Re: good style? Tambet Matiisen 06:42
two dates mixo 06:55
Re: Problem with deferred referential integrity checks Stephan Szabo 07:09
Re: Help with query involving aggregation and joining. Eddie Cheung 08:22
Re: good style? Rafal Kedziorski 08:44
Re: Sub Select inside Check ? Tomasz Myrta 11:29
STORAGE and GiST Itai Zukerman 14:06
Any limitation in size for return result from SELECT? Natasa Bulatovic 14:25
how can i drop a <unnamed> constraint rute solipa 14:55
Re: how can i drop a <unnamed> constraint Christoph Haller 15:05
Polymorphic? Itai Zukerman 15:09
Re: how can i drop a <unnamed> constraint Christoph Haller 15:23
Re: STORAGE and GiST Tom Lane 15:32
Re: Sub Select inside Check ? Stephan Szabo 15:50
Relation "pg_relcheck" Victor Yegorov 15:50
Re: Relation "pg_relcheck" Victor Yegorov 16:08
Re: Relation "pg_relcheck" Stephan Szabo 16:11
Re: Polymorphic? Tom Lane 16:20
Re: Relation "pg_relcheck" Ian Barwick 16:22
Re: Relation "pg_relcheck" Tom Lane 16:24
Re: Relation "pg_relcheck" Rod Taylor 16:34
Re: Denormalizing during select Josh Berkus 18:24
Re: Denormalizing during select Edmund Lian 18:48
Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 19:20
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Tom Lane 21:10
a change of query James Cooper 22:03
Re: a change of query Brad Hilton 22:39
Re: a change of query Chad Thompson 22:40
Re: a change of query Rod Taylor 22:50
Re: Help with query involving aggregation and joining. Josh Berkus 23:06

Feb. 26, 2003

Thread Author Time
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus 00:42
Postgres locking Bob Smith 00:55
Followup Re: Postgres locking Bob Smith 01:31
performance James Cooper 03:09
OffsetNumber, picksplit, and GiST Itai Zukerman 03:29
Re: Polymorphic? Itai Zukerman 03:40
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 04:43
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 04:48
Copy from a SELECT val 09:08
WebDB, iAS gyurika 13:19
Re: WebDB, iAS Victor Yegorov 13:21
Re: WebDB, iAS D'Arcy J.M. Cain 13:36
disable constraints rute solipa 14:38
Re: disable constraints Patrik Kudo 14:47
Design Q.:logic in app or db? george young 15:32
Re: OffsetNumber, picksplit, and GiST Itai Zukerman 15:54
Re: disable constraints rute solipa 16:50
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus 17:08
Re: Design Q.:logic in app or db? Josh Berkus 18:25
btree_gist, gint4_union Itai Zukerman 19:05
Re: Design Q.:logic in app or db? Achilleus Mantzios 19:58
Re: Relation "pg_relcheck" Tilo Schwarz 20:40
Re: Relation "pg_relcheck" Tom Lane 21:09
pgsql problem Grignon Etienne 22:46

Feb. 27, 2003

Thread Author Time
timestamp output as seconds since epoch? A.M. 01:14
Re: timestamp output as seconds since epoch? Rod Taylor 01:30
Re: how can i drop a <unnamed> constraint Christoph Haller 10:13
Re: Copy from a SELECT Christoph Haller 12:44
Re: pgsql problem Christoph Haller 14:41
Re: how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 15:53
using Avg() Mark Connelly@South Central 16:59
Re: Copy from a SELECT Valerie Goodman 18:28
Analyse article Dan Langille 18:51
GiST, Not Using Index Itai Zukerman 19:37
Re: Analyse article Dan Langille 19:59
Re: pgsql problem Grignon Etienne 20:33
Re: GiST, Not Using Index Tom Lane 20:51
use of geometric types in select ? dhoubrechts 21:07
Re: GiST, Not Using Index Itai Zukerman 21:15
Re: pgsql problem Stephan Szabo 22:04
Re: GiST, Not Using Index Tom Lane 22:38
Re: GiST, Not Using Index Itai Zukerman 23:12
Beginner needs help Aaron Chu 23:17

Feb. 28, 2003

Thread Author Time
Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev 00:45
Re: Are scalar type's in/out functions implicitly STRICT? Tom Lane 02:44
Re: Are scalar type's in/out functions implicitly STRICT? Bruno Wolff III 03:24
calling a stored procedure via pqSendQuery victor 03:44
PSQL segmentation fault? Frankie Lam 04:43
Re: pgsql problem Victor Yegorov 06:11
Executing SQL commands via triggers without the use of procedures 📎 Susan Hoddinott 06:31
Re: Copy from a SELECT Christoph Haller 09:34
Re: pgsql problem Christoph Haller 10:08
Query Against a dblink View Takes Too Long to Return Dawn Hollingsworth 12:54
Re: Copy from a SELECT val 13:24
Re: DELETE FROM t WHERE EXISTS Tomasz Myrta 13:28
Optimizing Montrone, Marc -- 7183 15:26
DELETE FROM t WHERE EXISTS Dan Langille 17:16
Re: WebDB, iAS Guy Fraser 17:57
Re: DELETE FROM t WHERE EXISTS Jakub Ouhrabka 19:25
Re: DELETE FROM t WHERE EXISTS Jeff Eckermann 19:30
Re: DELETE FROM t WHERE EXISTS Tom Lane 20:11
Re: DELETE FROM t WHERE EXISTS Stephan Szabo 20:34
Re: DELETE FROM t WHERE EXISTS Robert Treat 20:36
Re: DELETE FROM t WHERE EXISTS Dan Langille 21:56
Re: DELETE FROM t WHERE EXISTS Dan Langille 21:58
Re: DELETE FROM t WHERE EXISTS Dan Langille 22:01
Re: disable constraints Dmitry Tkach 22:42
Re: DELETE FROM t WHERE EXISTS Dmitry Tkach 22:47

Browse Archives

Prev | Next