pgsql-sql - June 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

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
Re: Re: [SQL] oracle rownum equivalent? Cary O'Brien 12:45
RE: ORDER BY in definition of views Michael Ansley 13:02
Re: Re: [SQL] oracle rownum equivalent? Gunnar R|nning 13:13
ORDER BY in definition of views Niall Smart 13:47
Re: Re: [SQL] oracle rownum equivalent? Tom Lane 14:38
Re: ORDER BY in definition of views Tom Lane 14:39
Re: ORDER BY in definition of views Niall Smart 15:41
SQL 'Case When...' 📎 Bernie Huang 17:01
trigger/refint question.. Michael J Schout 17:49
RE: Problem with subquery in CHECK constraint. Hiroshi Inoue 18:01
Re: Problem with subquery in CHECK constraint. Stephan Szabo 18:15
Sum of datetime différence... Ed 19:39
Help with inserts into Views Brian Powell 19:54
Is it possible to "truncate" a LOB? Stephen Crawley 23:29

June 9, 2000

Thread Author Time
RE: SQL 'Case When...' Oliver Graf 07:16
Trouble with creating tempoprary tables in plpgsql Alexander Stetsenko 08:48
Re: ORDER BY in definition of views Jan Wieck 10:17
Re: Problem with subquery in CHECK constraint. Niall Smart 11:08
Something I'd like to try... Niall Smart 11:18
Client Logging Bryan White 15:28
to convert a statement ... Benedykt P. Barszcz 20:59
WIDESPREAD INCOMPETENCE AT BELL ATLANTIC Speed-Demon 23:42

June 10, 2000

Thread Author Time
list & check tables psql mail 02:13
postmaster: init.d/start Markus Wagner 09:50
AUTO INCREMENT GANESH KUMAR 10:02
Re: AUTO INCREMENT M.Mazurek 10:05
Re: AUTO INCREMENT Lucile Dirry 10:34
BACK UP GANESH KUMAR 12:26
Re: BACK UP Poul L. Christiansen 12:29
Re: postmaster: init.d/start Daniel Fairs 12:43
SERIAL type does not generate new ID ? Jean-Marc Libs 17:28

June 11, 2000

Thread Author Time
Re: Client Logging Peter Eisentraut 11:45

June 12, 2000

Thread Author Time
Re: postmaster: init.d/start Markus Wagner 13:13
Newbie question on how to check triggers created Chunky 14:23
Re: Newbie question on how to check triggers created Ed Loehr 15:23
Re: Outer join in postgresql Peter Vazsonyi 18:21
Re: Outer join in postgresql Ed Loehr 19:23
Re: Outer join in postgresql Bruce Momjian 19:49
Becky is HERE !!!! 7970 yvkwbj 20:02
Outer join in postgresql Patrick Kay 21:01
Re: Outer join in postgresql Robert B. Easter 21:53
Problem regarding 'select...as...' 📎 Bernie Huang 22:32
Re: [PHP-DB] Problem regarding 'select...as...' Vince LaMonica 22:40
Simple search question Alex 23:42

June 13, 2000

Thread Author Time
Re: Outer join in postgresql Jesus Aneiros 01:01
Re: Simple search question John McKown 01:09
Re: Simple search question Alex 02:15
Re: Re: Simple search question Michael Fork 02:30
Re: postmaster: init.d/start Bill Anderson 03:30
sql foregein key GANESH KUMAR 04:43
Re: Problem regarding 'select...as...' Jesus Aneiros 05:18
Re: postmaster: init.d/start Thomas Mack 07:23
Re: question on diagnostics Bruce Momjian 08:01
Re: question on diagnostics Tom Lane 08:05
Re: sql foregein key Jan Wieck 09:58
Re: Simple search question John McKown 10:59
Re: Simple search question Peter Dixon 11:25
dump from access to pg on linux rocael 12:11
Re: sql foregein key Herbert Rabago Ambos 13:43
Q:Postgres 7.0 & Access'97? Emils Klotins 14:42

June 14, 2000

Thread Author Time
Re: dump from access to pg on linux Yury Don 04:01
attribute error Fred Lecul 04:21
Fwd: RE: dump from access to pg on linux Yury Don 04:59
Re: Q:Postgres 7.0 & Access'97? Yury Don 07:11
Some problem with inet type on PostgreSQL-7.0 Vadim Passynkov 15:02
Re: Outputting the Tables of a database Poul L. Christiansen 16:07
Outputting the Tables of a database Brian C. Doyle 16:46
Outputting the Tables of a database Brian C. Doyle 19:47
inheritance and primary key 📎 Bernie Huang 21:05

June 15, 2000

Thread Author Time
Re: Simple search question Alex 06:55
ANNOUNCE: pg_dumplo 0.0.5 Karel Zak 16:37
Re: ANNOUNCE: pg_dumplo 0.0.5 The Hermit Hacker 17:20
Re: Simple search question John McKown 18:17
\copy... Ed 18:32
Does anyone know of a function equivilant to Oracle's decode function? DalTech - Continuing Technical Education 18:38
Re: Re: Simple search question Stephan Szabo 19:09
find the number of rows for each table Patrick Coulombe 20:10
Re: ANNOUNCE: pg_dumplo 0.0.5 Karel Zak 21:16

June 16, 2000

Thread Author Time
Re: ANNOUNCE: pg_dumplo 0.0.5 The Hermit Hacker 03:51
using max() aggregate Louis-David Mitterrand 05:52
Determining Array size James Carpenter 06:41
Antw: using max() aggregate Gerhard Dieringer 07:28
Re: Antw: using max() aggregate Louis-David Mitterrand 08:11
Re: Antw: using max() aggregate Gerhard Dieringer 08:56
Re: Antw: using max() aggregate Louis-David Mitterrand 10:54
BETWEEN Joseph Shraibman 19:09

June 17, 2000

Thread Author Time
Null parm to a function Gordon Clarke 05:15
Re: Null parm to a function Tom Lane 05:46
Determining Array size. (HACK) 📎 James Carpenter 09:39
Re: Some problem with inet type on PostgreSQL-7.0 Peter Eisentraut 13:02
Database Transfer Craig May 23:07

June 18, 2000

Thread Author Time
Re: find the number of rows for each table Peter Eisentraut 14:16
Re: Database Transfer Peter Eisentraut 14:24
capacity of copy command?? rocael 18:38

June 19, 2000

Thread Author Time
Re: Database Transfer Kate Collins 08:49
the day after... Tulassay Zsolt 14:24
Re: the day after... Tom Lane 15:51

June 20, 2000

Thread Author Time
SQL92 and Traditional Toshihide Nakamura 01:27
Re: [SQL] Database Transfer Ferruccio Zamuner 15:19
Re: \copy... Webb Sprague 16:56
Re: Re: Simple search question mikeo 17:09
Re: BETWEEN Tom Lane 18:16
Type conversion Ice Planet 19:24
Re: Type conversion Tom Lane 19:48
Re: Type conversion Ed Loehr 20:05
Re: \copy... Christopher Sawtell 23:37

June 21, 2000

Thread Author Time
Sequences do not obey transactions... Ryan Kirkpatrick 02:36

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