Home > mailing lists

Mailing lists [pgsql-sql]

1 June 2000

02:13 question on diagnostics Alexander H. Iliev
03:38 Re: question on diagnostics Tom Lane
04:08 Re: question on diagnostics Alexander H. Iliev
04:17 Re: question on diagnostics Tom Lane
04:51 textpos() in postgreSQL 7.0 Adam Walczykiewicz
08:56 Data modelling tools Jorge Garcia
12:58 SQL Server and C++ Data Types Jason.Weiss@smed.com
13:11 Re: textpos() in postgreSQL 7.0 Ross J. Reedstrom
17:11 Re: SQL'92 web resources Bruce Momjian
17:24 short query becomes long mikeo
18:54 I'm missing outer joins bill@wadley.org
23:00 Simulating CURSORS?? p.lam@altavista.net

2 June 2000

01:32 Re: short query becomes long Tom Lane
05:33 creating rules on joined views Brian Powell
07:01 RE: psql problem Volker Paul
07:04 SPEED UP. Alessandro Rossi
07:19 Antw: Insert with replace? Gerhard Dieringer
08:50 pg_recvbuf : unexpected EOF on client Adam Walczykiewicz
11:57 Re: SPEED UP. Mitch Vincent
15:29 Re: SPEED UP. Patrick Giagnocavo
16:32 Deferral of primary key constraint Kyle Bateman
17:35 Benchmark Nikolaj Lundsgaard
19:45 Re: Deferral of primary key constraint JanWieck@t-online.de (Jan Wieck)
21:46 Re: Benchmark JanWieck@t-online.de (Jan Wieck)
22:41 Re: SQL'92 web resources Peter Eisentraut

3 June 2000

00:46 Re: SQL'92 web resources Bruce Momjian
08:21 @@Identity Craig May
19:00 Update table: extract max(hour). T.J.Farrell
19:30 LIKE vrs ~~ T.J.Farrell
23:26 Ho Ho Ho !!! 6684 qzhwjb@myhome.net

4 June 2000

00:41 Re: LIKE vrs ~~ Peter Eisentraut
18:21 Re: LIKE vrs ~~ Tom Lane

5 June 2000

06:37 Default timestamp value Rob S.
07:15 Re: Default timestamp value Thomas Behr
07:33 SQL functions - bug? Kovacs Zoltan Sandor
11:45 cron job INSERT appears to bail. Allan Kelly
13:28 [OT] Book on Postgres (Not a question) Poet/Joshua Drake
14:06 CREATE FUNCTION- Table as argument p.lam@altavista.net
14:28 Re: Default timestamp value Tom Lane
14:48 Re: cron job INSERT appears to bail. Tom Lane
14:53 Re: Default timestamp value Jeff Hoffmann
14:55 Re: SQL functions - bug? Tom Lane
14:55 Vacuum problem in my system ? Fabrice Scemama
15:20 Re: Vacuum problem in my system ? Tom Lane
15:42 RE: Default timestamp value Rob S.
17:26 Problem with array Bernie Huang
17:50 Re: Vacuum problem in my system ? Fabrice Scemama
17:58 ... Michael Fork
18:10 Index Scans Michael Fork
20:07 Finding number of updated rows in pl/pgsql Aaron Sethman
20:29 nested sub-select ? Chris Martin
23:08 Re: Vacuum problem in my system ? Tom Lane
23:35 Is it possible to "truncate" a LOB? Stephen Crawley

6 June 2000

01:01 moving DB
06:39 Re: moving DB Christopher Sawtell
11:11 Re: Vacuum problem in my system ? Rostislav Opocensky
12:55 Re: moving DB Kenn Thompson
14:13 New book on Postgres Ted Kennedy
14:46 Re: New book on Postgres bill@wadley.org
14:57 Re: New book on Postgres Pablo Prieto
23:01 Re: New book on Postgres Brett W. McCoy

10 June 2000

01:16 list & check tables psql mail
09:02 AUTO INCREMENT GANESH KUMAR
09:07 Re: AUTO INCREMENT M.Mazurek@poznan.multinet.pl
09:32 Re: AUTO INCREMENT Lucile Dirry
11:22 postmaster: init.d/start Markus Wagner
11:27 BACK UP GANESH KUMAR
11:47 Re: postmaster: init.d/start Daniel Fairs
12:27 Re: BACK UP Poul L. Christiansen

11 June 2000

10:45 Re: Client Logging Peter Eisentraut

12 June 2000

13:31 Newbie question on how to check triggers created Chunky
14:18 Re: Newbie question on how to check triggers created Ed Loehr
16:41 Re: postmaster: init.d/start Markus Wagner
17:29 Outer join in postgresql Patrick Kay
18:18 Re: Outer join in postgresql Peter Vazsonyi
18:18 Re: Outer join in postgresql Ed Loehr
18:50 Re: Outer join in postgresql Bruce Momjian
19:02 Becky is HERE !!!! 7970 yvkwbj@myhome.net
20:57 Re: Outer join in postgresql Robert B. Easter
21:32 Problem regarding 'select...as...' Bernie Huang
21:40 Re: [PHP-DB] Problem regarding 'select...as...' Vince LaMonica
22:41 Simple search question Alex

13 June 2000

00:39 Re: Outer join in postgresql Jesus Aneiros
00:59 Re: Simple search question newsuser@linux2.johnmckown.net (John McKown)
01:17 Re: Simple search question Alex
01:30 Re: Re: Simple search question Michael Fork
02:38 Re: postmaster: init.d/start Bill Anderson
03:43 sql foregein key GANESH KUMAR
04:23 Re: Problem regarding 'select...as...' Jesus Aneiros
04:46 Re: sql foregein key Herbert Rabago Ambos
06:23 Re: postmaster: init.d/start Thomas Mack
07:02 Re: question on diagnostics Bruce Momjian
07:06 Re: question on diagnostics Tom Lane
09:45 Re: sql foregein key JanWieck@t-online.de (Jan Wieck)
10:00 Re: Simple search question newsuser@linux2.johnmckown.net (John McKown)
17:11 dump from access to pg on linux

14 June 2000

03:15 Q:Postgres 7.0 & Access'97? Emils Klotins
03:22 Re: dump from access to pg on linux Yury Don
03:57 Fwd: RE: dump from access to pg on linux Yury Don
06:09 Re: Q:Postgres 7.0 & Access'97? Yury Don
13:10 attribute error Fred Lecul
13:11 Re: Simple search question Peter Dixon
15:47 Outputting the Tables of a database Brian C. Doyle
16:04 Re: Outputting the Tables of a database Poul L. Christiansen
18:48 Outputting the Tables of a database Brian C. Doyle
20:05 inheritance and primary key Bernie Huang

15 June 2000

02:55 Some problem with inet type on PostgreSQL-7.0 Vadim Passynkov
10:53 Re: Simple search question Alex
15:37 ANNOUNCE: pg_dumplo 0.0.5 Karel Zak
16:21 Re: ANNOUNCE: pg_dumplo 0.0.5 The Hermit Hacker
20:14 find the number of rows for each table Patrick Coulombe
20:16 Re: ANNOUNCE: pg_dumplo 0.0.5 Karel Zak

16 June 2000

02:52 Re: ANNOUNCE: pg_dumplo 0.0.5 The Hermit Hacker
03:43 Determining Array size James Carpenter
04:53 using max() aggregate Louis-David Mitterrand
06:36 Antw: using max() aggregate Gerhard Dieringer
07:11 Re: Antw: using max() aggregate Louis-David Mitterrand
08:04 Re: Antw: using max() aggregate Gerhard Dieringer
09:54 Re: Antw: using max() aggregate Louis-David Mitterrand

17 June 2000

04:23 Null parm to a function Gordon Clarke
04:46 Re: Null parm to a function Tom Lane
08:39 Determining Array size. (HACK) James Carpenter
11:56 Re: [BUGS] Some problem with inet type on PostgreSQL-7.0 Peter Eisentraut
22:07 Database Transfer Craig May

18 June 2000

13:10 Re: find the number of rows for each table Peter Eisentraut
13:30 Re: Database Transfer Peter Eisentraut
23:38 capacity of copy command??

19 June 2000

07:49 Re: Database Transfer Kate Collins
13:24 the day after... Tulassay Zsolt
14:52 Re: the day after... Tom Lane

20 June 2000

00:19 SQL92 and Traditional Toshihide Nakamura
15:42 \copy... Ed
15:50 Does anyone know of a function equivilant to Oracle's decode function? DalTech - Continuing Technical Education
15:54 Re: Simple search question John McKown
15:56 Re: \copy... Webb Sprague
15:57 Re: Re: Simple search question Stephan Szabo
16:00 Re: Re: Simple search question mikeo
16:22 BETWEEN Joseph Shraibman
17:17 Re: BETWEEN Tom Lane
18:26 Type conversion Ice Planet
18:49 Re: Type conversion Tom Lane
19:00 Re: Type conversion Ed Loehr
22:41 Re: \copy... Christopher Sawtell

21 June 2000

01:37 Sequences do not obey transactions... Ryan Kirkpatrick
13:50 Simply append... Ed
22:53 eliminating duplicates in results.. Francisco Hernandez

22 June 2000

19:14 Wildcard in date field??? Web Manager
19:30 Re: Wildcard in date field??? Dorin Grunberg
19:33 Re: Wildcard in date field??? Ed Loehr
19:44 Re: eliminating duplicates in results.. Jesus Aneiros
22:46 timespan casting Jeff MacDonald
23:37 Re: [GENERAL] Sequences do not obey transactions... Ryan Kirkpatrick

23 June 2000

00:51 Re: timespan casting Ed Loehr
01:43 Re: Using substr with user defined types darcy@druid.net (D'Arcy J.M. Cain)
02:06 Merging two columns into one Gary MacMinn
04:10 Re: Merging two columns into one Christopher Sawtell
04:47 Re: Using substr with user defined types Tom Lane
05:01 Re: Merging two columns into one Oliver Elphick
10:29 Re: Using substr with user defined types darcy@druid.net (D'Arcy J.M. Cain)
10:35 Re: Merging two columns into one darcy@druid.net (D'Arcy J.M. Cain)
10:40 Re: Merging two columns into one darcy@druid.net (D'Arcy J.M. Cain)
13:24 Orderby two different columns Mitch Vincent
13:33 Need to improve performance Vassili A Akimov
13:47 Re: Need to improve performance Mitch Vincent
14:43 Re: Merging two columns into one Jeff Hoffmann
14:52 Re: Using substr with user defined types Tom Lane
14:59 Re: Orderby two different columns Tom Lane
15:17 Re: Orderby two different columns Oliver Elphick
15:39 Re: Using substr with user defined types darcy@druid.net (D'Arcy J.M. Cain)
17:53 query failed , don't know why Jeff MacDonald
18:48 Speaking of fulltextindex... Mitch Vincent

24 June 2000

03:37 Re: [HACKERS] query failed , don't know why Tom Lane
04:15 Re: Wildcard in date field K Parker
17:21 More full text index.. Mitch Vincent
17:34 Re: More full text index.. Bruce Momjian
19:43 Re: More full text index.. Mitch Vincent
20:09 Re: More full text index.. Bruce Momjian

25 June 2000

01:19 Re: More full text index.. Tom Lane
06:53 finding (and recycling) holes in sequences Louis-David Mitterrand
22:13 JOIN syntax Oliver Elphick

26 June 2000

03:10 Re: JOIN syntax Thomas Lockhart
14:37 finding (and recycling) holes in sequences Kyle Bateman
15:37 A subselect in an aggregate Bryan White
15:52 Re: A subselect in an aggregate Ed Loehr
16:04 pg_dump problem Graham Vickrage
16:46 Re: pg_dump problem Ed Loehr
18:04 Re: A subselect in an aggregate Bryan White
21:32 Re: A subselect in an aggregate Tom Lane
22:11 Re: Merging two columns into one Gary MacMinn
23:02 Sub_select problem Bernie Huang

27 June 2000

03:52 Re: unique sequences K Parker
06:49 Re: pg_dump problem drfrog@smartt.com
10:15 Re: Re: unique sequences DalTech - Continuing Technical Education
12:09 Backup? Emils Klotins
13:43 Re: Backup? Tom Lane
15:15 Creating tables from within functions Saltsgaver, Scott
15:17 Re: Backup? Bryan White
15:28 Problem with pg_dumpall Ryan Bradetich
20:50 Re: Problem with pg_dumpall Tom Lane
20:55 Re: Problem with pg_dumpall Ryan Bradetich
21:02 Re: Problem with pg_dumpall Tom Lane
22:14 Re: Problem with pg_dumpall Ryan Bradetich
22:17 Problem with pg_dumpall in reverse Kenn Thompson
23:56 HI! Problems with cursors into triggers Andrés Mauricio Marín Restrepo

28 June 2000

04:29 Hash Join not using hashed index? Ang Chin Han
05:15 Re: Problem with pg_dumpall Tom Lane
06:00 Re: Hash Join not using hashed index? Tom Lane
06:43 Selecting outside the current DB Ben Stringer
09:05 extract last months data Antti Linno
09:29 trigger or something else? Emils Klotins
09:54 Re: trigger or something else? Karel Zak
10:36 Re: extract last months data Guillaume Perréal
13:10 Re: extract last months data Thomas Lockhart
13:12 HI! Problems with cursors into triggers Andrés Mauricio Marín Restrepo
13:56 Re: Hash Join not using hashed index? Tom Lane
14:31 Re: finding (and recycling) holes in sequences Erik Tennant
16:33 retrieving a serial number Lea, Michael
16:44 Procedures cannot take more than 16 arguments Andrey
16:52 Re: Procedures cannot take more than 16 arguments Bruce Momjian
17:12 Re: Procedures cannot take more than 16 arguments Tom Lane
17:30 Re: retrieving a serial number philip@adhesivemedia.com (Philip Hallstrom)
17:50 Finding the names of inheriting classes Thomas Swan
18:46 Re: HI! Problems with cursors into triggers Robert B. Easter
19:17 Re: retrieving a serial number Robert B. Easter
19:23 temporay table : error is repeated. Patrick Coulombe

29 June 2000

00:55 Re: Finding the names of inheriting classes Tom Lane
02:15 Re: Hash Join not using hashed index? Tom Lane
02:54 Re: Finding the names of inheriting classes Thomas Swan
15:44 select from table Kovacs Zoltan Sandor

30 June 2000

18:06 some strings from errlog Vadim Passynkov
20:20 Which procedural language to use for functions. Saltsgaver, Scott
21:25 Re: some strings from errlog Tom Lane