pgsql-sql since 2000-05-25 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

May 25, 2000

Thread Author Time
Re: [HACKERS] Chris Bitmead 00:02
Re: possible bug with group by? Tom Lane 02:59
Re: Use of index in 7.0 vs 6.5 Tom Lane 03:12
Re: Use of index in 7.0 vs 6.5 Ryan Bradetich 03:57
Re: [SQL] Michael A. Mayo 04:54
Re: Use of index in 7.0 vs 6.5 Tom Lane 06:14
RE: Use of index in 7.0 vs 6.5 Hiroshi Inoue 07:19
RE: Use of index in 7.0 vs 6.5 Mikheev, Vadim 14:29
Re: Use of index in 7.0 vs 6.5 Tom Lane 14:39
Re: Use of index in 7.0 vs 6.5 Bruce Momjian 15:11
Re: Use of index in 7.0 vs 6.5 Jeff Hoffmann 15:30
Re: Use of index in 7.0 vs 6.5 Tom Lane 16:03
Re: Use of index in 7.0 vs 6.5 Tom Lane 16:08
Re: Use of index in 7.0 vs 6.5 Bruce Momjian 16:08
RE: Use of index in 7.0 vs 6.5 Mikheev, Vadim 16:12
RE: Use of index in 7.0 vs 6.5 Mikheev, Vadim 17:17
Re: Use of index in 7.0 vs 6.5 Ryan Bradetich 23:40

May 26, 2000

Thread Author Time
RE: Use of index in 7.0 vs 6.5 Hiroshi Inoue 00:02
Re: Use of index in 7.0 vs 6.5 Tom Lane 00:03
aliases break my query Joseph Shraibman 03:11
Re: aliases break my query Tom Lane 04:35
PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state' Markus Wagner 06:21
Antw: aliases break my query Gerhard Dieringer 06:54
A Question Sherril Mathew 10:53
Re: A Question Peter Eisentraut 12:48
Re: aliases break my query Peter Eisentraut 13:02
Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state' Ed Loehr 13:42
date() indexing error.. Mitch Vincent 14:31
Re: date() indexing error.. Tom Lane 15:52
POSTGRESQL and PERL? Peter Landis 15:58
RE: POSTGRESQL and PERL? 📎 Wallingford, Ted 16:14
Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state' Tom Lane 16:19
Re: aliases break my query Tom Lane 16:26
Re: POSTGRESQL and PERL? Ed Loehr 16:35
Re: POSTGRESQL and PERL? Richard Huxton 17:41
Re: aliases break my query Joseph Shraibman 17:47
Re: aliases break my query Joseph Shraibman 18:13
Re: Re: [SQL] aliases break my query Zeugswetter Andreas 19:47
New Type Olivier PRENANT 20:03
is limit a reserved keyword? Gabriel Russell 21:24
Re: Re: [SQL] aliases break my query Tom Lane 21:34
Re: Re: [SQL] aliases break my query Peter Eisentraut 22:30
Re: Re: [SQL] aliases break my query Tom Lane 22:42
Re: [SQL] is limit a reserved keyword? Tom Lane 22:48
Re: Re: [SQL] aliases break my query Bruce Momjian 23:43

May 27, 2000

Thread Author Time
Re: Re: [SQL] aliases break my query Mike Mascari 01:45
Re: Re: [SQL] aliases break my query Tom Lane 04:06
Re: New Type selkovjr 07:22
joins again CB 10:29
Re: joins again Erol Oz 11:41
PL/pgSQL Antony Sakellariou 20:03

May 28, 2000

Thread Author Time
Re: Re: [SQL] aliases break my query Andreas Zeugswetter 07:34
plpgsql variable substitution problem ... Greg Wickham 17:48
Re: plpgsql variable substitution problem ... Tom Lane 18:15

May 29, 2000

Thread Author Time
date format Carolyn Wong 05:37
Rollback & Nextval fails Eriksson, Fredrik 08:54
Antw: Rollback & Nextval fails Gerhard Dieringer 09:44
Re: Rollback & Nextval fails Grant Finnemore 09:50
adding fields containing NULL values Werner Modenbach 11:58
Re: adding fields containing NULL values Grant Finnemore 13:43
template or index of some kind 📎 Bernie Huang 16:21
constraint 📎 Bernie Huang 17:22
Re: constraint Jan Wieck 20:59
storing images! 📎 Bernie Huang 21:09

May 30, 2000

Thread Author Time
create constraint trigger 📎 Kyle Bateman 00:13
Max date in the month Tubagus Nizomi 03:54
Re: 7.0 weirdness omid omoomi 06:46
RE: 7.0 weirdness omid omoomi 07:13
Inheritance Christophe Labouisse 10:16
Re: Inheritance Peter Eisentraut 10:41
7.0 weirdness Jeff MacDonald 12:28
RE: 7.0 weirdness Patrick FICHE 13:17
RE: 7.0 weirdness Jeff MacDonald 13:46
Re: 7.0 weirdness Jeff MacDonald 14:10
Re: [HACKERS] Re: 7.0 weirdness Matthias Urlichs 14:31
Re: 7.0 weirdness Tom Lane 14:44
Re: [SQL] remove line type? mikeo 15:35
Pg/PLSQL Errors!! p.lam 16:36
Re: Pg/PLSQL Errors!! Karel Zak 16:37
Re: Pg/PLSQL Errors!! Tulassay Zsolt 16:57
Re: Pg/PLSQL Errors!! Frank G Hahn 17:01
Re: Pg/PLSQL Errors!! Tom Lane 17:19
Insert with replace? Steve Wampler 17:36
Re: Re: [SQL] remove line type? Tom Lane 17:41
Function-based index not used in a simple query Rostislav Opocensky 18:31
Re: Re: [SQL] remove line type? mikeo 19:07
Re: Function-based index not used in a simple query Tom Lane 21:36
Re: Use of index in 7.0 vs 6.5 Ryan Bradetich 23:48

May 31, 2000

Thread Author Time
does the' text' type cann't store more than 20,000char ? xu hai 01:11
Re: does the' text' type cann't store more than 20,000char ? Mitch Vincent 01:49
Re: [HACKERS] Re: aliases break my query Thomas Lockhart 02:04
Re: Pg/PLSQL Errors!! SL Baur 04:31
Re: Re: Pg/PLSQL Errors!! Tom Lane 05:58
Re: 7.0 weirdness Peter Vazsonyi 06:45
Re: Function-based index not used in a simple query Rostislav Opocensky 10:33
create view security 📎 Wallingford, Ted 12:45
Re: Function-based index not used in a simple query 📎 Tom Lane 15:53
psql problem Rick Parker 16:51
Re: psql problem Ed Loehr 17:21
Re: psql problem Mitch Vincent 17:36
TOP SESSIONS? 📎 mikeo 18:41
creating rules on joined views Brian Powell 18:55
Re: [HACKERS] Re: 7.0 weirdness Jeff MacDonald 19:00
Inheritance heirarchy Jon Parise 19:05
Re: create view security Peter Eisentraut 19:35
Re: create constraint trigger 📎 Kyle Bateman 19:56
Re: TOP SESSIONS? Mike Mascari 23:32

June 1, 2000

Thread Author Time
Re: [SQL] Re: create view security Jan Wieck 02:24
question on diagnostics Alexander H. Iliev 03:12
Re: question on diagnostics Tom Lane 04:37
Re: question on diagnostics Alexander H. Iliev 05:07
Re: question on diagnostics Tom Lane 05:16
textpos() in postgreSQL 7.0 Adam Walczykiewicz 05:47
Data modelling tools 📎 Jorge Garcia 09:49
SQL Server and C++ Data Types Jason.Weiss 13:57
Re: textpos() in postgreSQL 7.0 Ross J. Reedstrom 14:10
Re: SQL'92 web resources Bruce Momjian 18:10
short query becomes long mikeo 18:24
I'm missing outer joins bill 19:53
Simulating CURSORS?? p.lam 23:59

June 2, 2000

Thread Author Time
Re: short query becomes long Tom Lane 02:31
SPEED UP. Alessandro Rossi 06:49
Antw: Insert with replace? Gerhard Dieringer 07:02
RE: psql problem Volker Paul 07:10
pg_recvbuf : unexpected EOF on client Adam Walczykiewicz 09:47
Re: SPEED UP. Mitch Vincent 12:57
Re: SPEED UP. Patrick Giagnocavo 15:25
Deferral of primary key constraint 📎 Kyle Bateman 15:34
Benchmark Nikolaj Lundsgaard 18:35
Re: Deferral of primary key constraint Jan Wieck 19:14
Re: Benchmark Jan Wieck 20:58
Re: SQL'92 web resources Peter Eisentraut 23:46

June 3, 2000

Thread Author Time
Re: SQL'92 web resources Bruce Momjian 01:46
@@Identity Craig May 09:26
Update table: extract max(hour). T.J.Farrell 20:02
LIKE vrs ~~ T.J.Farrell 20:31

June 4, 2000

Thread Author Time
Ho Ho Ho !!! 6684 qzhwjb 00:24
Re: LIKE vrs ~~ Peter Eisentraut 01:46
Re: LIKE vrs ~~ Tom Lane 19:19

June 5, 2000

Thread Author Time
Default timestamp value Rob S. 07:34
Re: Default timestamp value Thomas Behr 08:13
SQL functions - bug? Kovacs Zoltan Sandor 08:32
Problem with joins Jean-Marc Libs 10:47
cron job INSERT appears to bail. Allan Kelly 12:35
[OT] Book on Postgres (Not a question) Poet/Joshua Drake 13:25
Re: Antw: Problem with joins Jean-Marc Libs 13:48
CREATE FUNCTION- Table as argument p.lam 15:05
Re: Default timestamp value Tom Lane 15:27
Re: cron job INSERT appears to bail. Tom Lane 15:47
Re: Default timestamp value Jeff Hoffmann 15:52
Re: SQL functions - bug? Tom Lane 15:55
Re: Vacuum problem in my system ? Tom Lane 16:19
RE: Default timestamp value Rob S. 16:41
Vacuum problem in my system ? Fabrice Scemama 17:43
Problem with array 📎 Bernie Huang 18:27
[No subject] Michael Fork 18:58
Index Scans Michael Fork 19:10
moving DB rocael 20:01
Re: Vacuum problem in my system ? Fabrice Scemama 20:36
Finding number of updated rows in pl/pgsql Aaron Sethman 21:08
nested sub-select ? Chris Martin 21:29

June 6, 2000

Thread Author Time
Re: Vacuum problem in my system ? Tom Lane 00:08
Is it possible to "truncate" a LOB? Stephen Crawley 00:35
Re: [SQL] moving DB Christopher Sawtell 07:33
Re: Vacuum problem in my system ? Rostislav Opocensky 12:11
Re: moving DB Kenn Thompson 13:54
New book on Postgres Ted Kennedy 15:13
Re: New book on Postgres bill 15:50
Re: New book on Postgres Pablo Prieto 16:57

June 7, 2000

Thread Author Time
Re: New book on Postgres Brett W. McCoy 00:01
how to know when a table is altered Vincenzo Passoli 05:24
sql doubts Gustavo Henrique 11:53
oracle rownum equivalent? mikeo 12:24
Re: sql doubts Frank G Hahn 13:25
Re: [SQL] oracle rownum equivalent? Ed Loehr 13:29
Re: how to know when a table is altered Ed Loehr 13:36
Re: [SQL] oracle rownum equivalent? mikeo 14:14
Temp table and loop call from one session Dmitriy Yusupov 14:21
Problem with subquery in CHECK constraint. Niall Smart 15:24
Re: [SQL] oracle rownum equivalent? Ed Loehr 15:37
Re: Problem with subquery in CHECK constraint. Tom Lane 15:48
Re: how to know when a table is altered Ed Loehr 16:49
[No subject] Steffers 16:54
RE: Re: how to know when a table is altered Vincenzo Passoli 16:57
Please ignore [PSQL and PHP] 📎 Bernie Huang 18:20
Re: Re: [SQL] oracle rownum equivalent? Cary O'Brien 22:47
counting distinct values Joseph Shraibman 23:52

June 8, 2000

Thread Author Time
Re: counting distinct values Bruce Momjian 00:15
Fetch an element in an array 📎 Bernie Huang 00:21
RE: Problem with subquery in CHECK constraint. Hiroshi Inoue 00:24
References and privileges 📎 Kyle Bateman 00:45
Re: counting distinct values Joseph Shraibman 01:04
Re: Fetch an element in an array omid omoomi 01:05
Re: how to know when a table is altered Ed Loehr 02:32
Re: counting distinct values Tom Lane 02:46
Re: counting distinct values Joseph Shraibman 03:09
RE: Re: [SQL] oracle rownum equivalent? Hiroshi Inoue 04:47
Re: Jan Wieck 10:50
Re: Problem with subquery in CHECK constraint. Niall Smart 11:56
Re: Re: [SQL] oracle rownum equivalent? mikeo 12:20

Browse Archives

Prev | Next