pgsql-sql - June 2000

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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