pgsql-sql - January 2000

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

Jan. 1, 2000

Thread Author Time
timespan problem Tulassay Zsolt 20:48
Re: [SQL] timespan problem Tom Lane 23:58

Jan. 2, 2000

Thread Author Time
unsubscribe lyman1 15:12

Jan. 3, 2000

Thread Author Time
Re: [SQL] timespan problem Thomas Lockhart 07:38
Re: [SQL] timespan problem Thomas Lockhart 08:48
Re: [SQL] timespan problem Tom Lane 15:05
restriction clause selectivity bad value Wallingford, Ted 17:00
Re: [ADMIN] restriction clause selectivity bad value Marcio Macedo 17:15
Re: [ADMIN] restriction clause selectivity bad value Bruce Momjian 17:19
Re: [ADMIN] restriction clause selectivity bad valueu Bruce Momjian 17:20

Jan. 4, 2000

Thread Author Time
Triggers Mitch Vincent 15:04
Re: [SQL] Triggers Tom Lane 15:55
Re: [SQL] Triggers Mitch Vincent 16:21
Re: [SQL] Triggers Jan Wieck 18:42
Re: [SQL] Triggers Matthew Hagerty 19:27

Jan. 5, 2000

Thread Author Time
Calculation dependencies in views Rick Delaney 00:14
Re: [SQL] datetime fields have '60' in seconds field omid omoomi 00:37
Re: [SQL] Calculation dependencies in views Jan Wieck 01:03
Re: [SQL] Calculation dependencies in views Tom Lane 05:35
plpgsql bug(?) Kovacs Zoltan 10:25
Re: [SQL] plpgsql bug(?) Jan Wieck 15:05
Re: [SQL] datetime fields have '60' in seconds field Tom Lane 15:32
Re: [SQL] Calculation dependencies in views Rick Delaney 20:14
Re: [SQL] Calculation dependencies in views Rick Delaney 20:15
Re: [SQL] Calculation dependencies in views Jan Wieck 21:49
Re: [SQL] Calculation dependencies in views Rick Delaney 23:13

Jan. 6, 2000

Thread Author Time
Re: [SQL] Calculation dependencies in views Jan Wieck 00:10
Autonumber column Bron Till 00:40
Re: [SQL] Autonumber column Bruce Momjian 01:32
Re: [SQL] Calculation dependencies in views Tom Lane 01:47
Re: [SQL] Autonumber column Vladimir Terziev 08:24
Re: [SQL] Calculation dependencies in views Rick Delaney 19:42

Jan. 7, 2000

Thread Author Time
Serial field starting at 100 ? Richard Walker 02:35
Re: [SQL] Serial field starting at 100 ? Vladimir Terziev 15:56
Is there something wrong with datatype float8 ??? Ana Roizen 17:00
Re: [SQL] datetime fields have '60' in seconds field Werner Fraga 19:19

Jan. 8, 2000

Thread Author Time
createdb -D xxxx not working Chris Griffin 06:02
Re: [SQL] createdb -D xxxx not working Tom Lane 06:47
Could this be done better...? The Hermit Hacker 07:03

Jan. 9, 2000

Thread Author Time
can't seem to use index admin 21:33
Re: [SQL] Serial field starting at 100 ? Richard Walker 23:02

Jan. 10, 2000

Thread Author Time
Simmultanous Connections Jude Weaver 09:21
Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? Tom Lane 15:17
Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? Alain TESIO 19:14
problems creating functions, triggers, and rules Werner Fraga 20:54
query to do a backward 'skip', possible with (index) optimization ? Albert Loo 21:15
problems creating functions and triggers Werner Fraga 22:32

Jan. 11, 2000

Thread Author Time
Re: [SQL] problems creating functions and triggers Tom Lane 00:40
Re: [SQL] createdb -D xxxx not working Peter Eisentraut 13:26
Re: [SQL] createdb -D xxxx not working Tom Lane 15:14
best strategy doing a large copy and using indexes Dirk Lutzebaeck 15:21
Re: [HACKERS] Re: [SQL] createdb -D xxxx not working Thomas Lockhart 15:57
Re: [SQL] best strategy doing a large copy and using indexes Tom Lane 16:14
Problem with array syntax Web Manager 20:29
Problem with array syntax Web Manager 21:00

Jan. 12, 2000

Thread Author Time
Re: [HACKERS] Re: [SQL] createdb -D xxxx not working Peter Eisentraut 03:30
mdopen: couldn't open Prakash 07:56
simple question Thomas Leavitt 10:10
function parameters/output values Thomas Leavitt 10:29
stats on select admin 12:12
help. Alexandr Listopad 13:44
Re: [HACKERS] Re: [SQL] createdb -D xxxx not working Thomas Lockhart 16:26
Not Allowing Users to Create Tables Neil Cameron 17:19
Rules, triggers, ??? - What is the best way to enforce data-valid ation tests? Greg Youngblood 17:52
Re: [SQL] query to do a backward 'skip' ...thanks, it's working. Albert Loo 20:53
proposal -- Re: [HACKERS] Re: [SQL] createdb -D xxxx not working Peter Eisentraut 23:29
Re: [SQL] function parameters/output values Peter Eisentraut 23:29

Jan. 13, 2000

Thread Author Time
RE: [SQL] function parameters/output values Thomas Leavitt 00:40
Getting environment variables? mpg4 02:25
foreign key implementation Pausas Fuentes, Jaume 11:14
Re: [SQL] foreign key implementation Oliver Elphick 21:21

Jan. 14, 2000

Thread Author Time
key set delete query Michael McCarthy 08:09
Optimizing ORDER BY with indexes? Dirk Lutzebaeck 08:41
Re: [SQL] Optimizing ORDER BY with indexes? Dirk Lutzebaeck 09:31
Re: [SQL] Optimizing ORDER BY with indexes? Dirk Lutzebaeck 09:34
Re: [SQL] key set delete query Tom Lane 15:02
Re: [SQL] Optimizing ORDER BY with indexes? Tom Lane 15:18
Re: [SQL] Optimizing ORDER BY with indexes? Bruce Momjian 16:37
numeric question.. Mitch Vincent 16:56
Aggregates and Views Mark Volpe 21:16
Re: Aggregates & Views Mark Volpe 21:19
Re: [SQL] numeric question.. Tom Lane 21:27
Re: [SQL] numeric question.. Mitch Vincent 21:39
Re: [SQL] Aggregates and Views Tom Lane 22:26
Re: [SQL] numeric question.. Tom Lane 23:09

Jan. 15, 2000

Thread Author Time
(no subject) 📎 Michal Frajt 11:19

Jan. 16, 2000

Thread Author Time
Patches for various NUMERIC bugs posted on pgsql-patches Tom Lane 01:07
[No subject] Egon Rothenberger 12:51
attribute level rules not supported? Marc Tardif 13:20
Re: [SQL] Getting environment variables? Peter Eisentraut 17:13
Re: [SQL] numeric question.. Peter Eisentraut 17:14
Re: [SQL] numeric question.. Tom Lane 17:35

Jan. 17, 2000

Thread Author Time
Antw: [SQL] attribute level rules not supported? Gerhard Dieringer 08:12
index usage ... strange !? Marten Feldtmann 19:29
Re: [SQL] index usage ... strange !? Tom Lane 22:26

Jan. 18, 2000

Thread Author Time
ordering operator for bytea Michael McCarthy 04:14
Re: [SQL] ordering operator for bytea Tom Lane 05:06
Re: [SQL] index usage ... strange !? Marten Feldtmann 06:53
Re: [SQL] Ordering a date_part() query ... omid omoomi 10:48
Re: [SQL] Ordering a date_part() query ... omid omoomi 10:48
char(19) to varchar(32) Marc Tardif 14:04
Ordering a date_part() query ... The Hermit Hacker 17:20
Re: [SQL] Ordering a date_part() query ... Mark Volpe 17:45
Re: [SQL] Ordering a date_part() query ... Bruce Momjian 18:26
Re: [SQL] Ordering a date_part() query ... Bruce Momjian 18:28
Re: [SQL] Ordering a date_part() query ... Mark Volpe 18:49
Re: [SQL] Ordering a date_part() query ... Bruce Momjian 19:06
Re: [SQL] Ordering a date_part() query ... The Hermit Hacker 19:16
Re: [SQL] Ordering a date_part() query ... Tom Lane 19:45
Re: [SQL] Ordering a date_part() query ... The Hermit Hacker 21:06
Re: [SQL] Ordering a date_part() query ... Tom Lane 22:26
Re: [SQL] Ordering a date_part() query ... The Hermit Hacker 22:43

Jan. 19, 2000

Thread Author Time
Re: [SQL] char(19) to varchar(32) Marc Tardif 10:56
Bug in CEIL? Mark Alliban 12:13
Bug in CEIL? Mark Alliban 13:26
Re: [SQL] char(19) to varchar(32) Jose Soares 14:01
Re: [SQL] Bug in CEIL? Nikolay Mijaylov 14:05
Re: [SQL] Bug in CEIL? Tom Lane 15:02
Re: [SQL] Foreign Keys, Triggers and such Marc Tardif 15:40
Re: [SQL] char(19) to varchar(32) Tom Lane 15:41
(no subject) Sevo Stille 16:32
Re: [GENERAL] Re: [SQL] Bug in CEIL? Bruce Momjian 17:07
Re: [SQL] char(19) to varchar(32) Tom Lane 17:24
Re: [SQL] index usage ... strange !? Marten Feldtmann 17:46
Re: [SQL] index usage ... strange !? Tom Lane 18:07
Re: [SQL] char(19) to varchar(32) Tom Lane 18:11
Foreign Keys, Triggers and such Daniel Spratlen 19:16

Jan. 20, 2000

Thread Author Time
null and integer field Hamid Khoshnevis 00:57
Re: [SQL] null and integer field Tom Lane 02:20
round() and || Graeme Merrall 02:42
Re: [SQL] round() and || Tom Lane 06:34
inserting values into arrays T.I.P. 08:16
[SQL] inserting values into arrays T.I.P. 09:19
inserting values into arrays Kovacs Zoltan 09:27
Help for performance dLux 11:54
Re: [SQL] crypt in Postgres? Peter Eisentraut 11:58
inserting values into arrays Kovacs Zoltan 12:30
sql performance help needed dLux 12:56
inserting values into arrays T.I.P. 13:07
insert values into arrays Kovacs Zoltan Sandor 13:35
insert values into arrays Kovacs Zoltan Sandor 13:40
crypt in Postgres? Emils Klotins 13:47
Geometric types in SELECT? mpg4 13:52
Re: [SQL] crypt in Postgres? D'Arcy J.M. Cain 13:53
Re: [SQL] crypt in Postgres? Peter Mount 14:39
inserting values into arrays Thomas Lockhart 15:24
Re: [SQL] insert values into arrays Peter Eisentraut 21:55

Jan. 21, 2000

Thread Author Time
Re: [SQL] Geometric types in SELECT? Tom Lane 01:22
(no subject) david tzuriel 12:25
[No subject] 13:46
Problem with large tuples. Patrik Kudo 15:05
Duplicate tuples with unique index Patrik Kudo 15:09
Re: [SQL] Problem with large tuples. Dirk Lutzebaeck 15:38
Re: [SQL] Duplicate tuples with unique index Tom Lane 16:23
psql - odbc - bde - data dictionary Tibor Laszlo 16:53
DISTINCT and aggregates Brook Milligan 17:00
[No subject] Tibor Laszlo 17:59
Re: [SQL] DISTINCT and aggregates Tom Lane 18:38
Re: [SQL] SQL Things De Moudt Walter 23:50

Jan. 22, 2000

Thread Author Time
SQL Things Neil Cameron 01:14
More efficient DELETE ... ? The Hermit Hacker 17:20
Re: [SQL] More efficient DELETE ... ? Bruce Momjian 17:56
geo_distance radius question Mark Stosberg 18:06
Re: [SQL] More efficient DELETE ... ? Tom Lane 18:07
Repost: restore from dump problem - query buffer full Web Manager 18:28
Re: [SQL] More efficient DELETE ... ? Bruce Momjian 19:37
how many inserts in one transaction? gav 21:15
Re: [SQL] More efficient DELETE ... ? Tom Lane 21:43
Re: [SQL] More efficient DELETE ... ? The Hermit Hacker 23:18

Jan. 23, 2000

Thread Author Time
Re: [SQL] SQL Things Peter Eisentraut 01:29
Re: [SQL] how many inserts in one transaction? Christopher Sawtell 07:21
(no subject) Dmitry A. Alyekhin 08:53
pqReadData... gav 13:44
Re: [SQL] pqReadData... Tom Lane 16:18
Join-Question Dorthe Luebbert 18:38
Re: [SQL] Join-Question Borek.Lupomesky 22:38

Jan. 24, 2000

Thread Author Time
can I index a field of type "point"? Mark Stosberg 00:36
Re: [SQL] can I index a field of type "point"? Gene Selkov, Jr. 02:24
Question about COPY command Mercury He 04:11
Re: [SQL] Duplicate tuples with unique index Patrik Kudo 10:00
Re: [SQL] Question about COPY command Christopher Sawtell 10:48
Re: [SQL] Blobs Mathijs Brands 15:54
Backend crash Mark Volpe 16:14
Fwd: Re: [SQL] Blobs Compte utilisateur Sultan-advl 16:16
Backend crash Mark Volpe 16:25
Re: [SQL] Backend crash Tom Lane 17:16
Re: [SQL] Backend crash Bruce Momjian 17:17
Re: [SQL] Backend crash Mark Volpe 18:58
Re: [SQL] Backend crash Bruce Momjian 19:08
Re: [SQL] Join-Question De Moudt Walter 20:09
Re: [SQL] Backend crash Alain TESIO 20:58
Re: [SQL] Backend crash Bruce Momjian 22:31
Blobs Neil Cameron 22:33
Re: [SQL] Blobs Peter Eisentraut 23:49

Jan. 25, 2000

Thread Author Time
DISTINCT ON: speak now or forever hold your peace Tom Lane 01:50
JDK1.2 Driver to Postgresql 6.5.3 - connection problem Tom Donaldson 01:54
Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Chris Bitmead 02:41
Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Mike Mascari 02:50
Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Philip Warner 03:03
Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Bruce Momjian 03:09

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