pgsql-sql since 1998-09-08 00:00

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

Sept. 8, 1998

Thread	Author	Time
Re: [SQL] Datetime in humane format	Eric McKeown	00:32
(no subject)	jmjang	01:45
Looking for easy SQL documentation!	Jerome Knobl	05:27
subscribe	David Ben-Yaacov	13:08
Re: [SQL] Looking for easy SQL documentation!	Kevin O' Gorman	14:04
SubQuery speed	andreas.fredriksson	14:45
Re: [SQL] Looking for easy SQL documentation!	Kevin O' Gorman	14:54
Re: [SQL] SubQuery speed	Herouth Maoz	15:10
Re: [SQL] Looking for easy SQL documentation!	Leslie Mikesell	16:36
Re: [SQL] Creating Indexes for MAC and IP Data Types	Craig Orsinger	17:22

Sept. 9, 1998

Thread	Author	Time
Re: [SQL] SubQuery speed	Vadim Mikheev	02:29
Loading Array data from delimited ascii files	Jim Jennis	13:45
[No subject]	John Palmer	16:03
Re: [SQL] Loading Array data from delimited ascii files	Eric McKeown	18:55
RE:	Craig Orsinger	21:09

Sept. 10, 1998

Thread	Author	Time
[No subject]	XuYifeng	00:53
sorry... ;^)	Thierry VERMAT	08:45
Thank You	John Palmer	11:29
TimeStamp for insert/update	Zsolt Varga	13:54
Binary variable length string	Juan Valero	17:12

Sept. 11, 1998

Thread	Author	Time
connecting with password	Eric McKeown	02:18
Re: [SQL] connecting with password	Daniele Orlandi	02:31
Re: [SQL] connecting with password	D'Arcy J.M. Cain	03:11
Linux ODBC DRIVER ?	Marcio Macedo	17:21
Re: [SQL] connecting with password	Eric McKeown	18:12

Sept. 14, 1998

Thread	Author	Time
Aggregate functions on DATE and TIME	Sverre H. Huseby	07:32
Re: [PHPLIB] SQL probs with phplib	Szandor van Verseveld	09:23
Re: [PHPLIB] SQL probs with phplib	Kristian =?iso-8859-1?Q?K=F6hntopp?=	09:28
Re: [SQL] SQL probs with phplib	David Hartwig	20:10
SQL probs with phplib	Oliver Duke-Williams	23:57

Sept. 15, 1998

Thread	Author	Time
CREATE GROUP?	Vladimir Sovetov	01:16
subscribe pgsql-sql	Howie	18:43
varchar vs. upper(), lower() etc.	Leslie Mikesell	18:46
Primary and foreign key	Daniel Facciolo Pires	21:24

Sept. 16, 1998

Thread	Author	Time
create a new user in a group	maloune	12:33
Re: [SQL] create a new user in a group	Sferacarta Software	13:35
Re: [SQL] How to Make Case InSensitive???	Barracuda	13:48
Re[2]: [SQL] How to Make Case InSensitive???	Sferacarta Software	14:14
Re[2]: [SQL] How to Make Case InSensitive???	Herouth Maoz	14:42
Re: [SQL] How to Make Case InSensitive???	Bruce Momjian	17:30
rtree, btree, hash index methods...should I care?	Patrick Giagnocavo	18:19

Sept. 17, 1998

Thread	Author	Time
Re: [SQL] How to Make Case InSensitive???	Jerome Knobl	08:13
Datetime field	Henrik Denseje Pedersen	10:46
Re: [SQL] Datetime field	Jose' Soares	13:28
Turn autocommit off ?	Andreas Joppich	14:12
Re: [SQL] Turn autocommit off ?	Federico Passaro	14:46
IF..THEN..ELSE	David J. Haglin	15:46
Re: [SQL] Turn autocommit off ?	Bruce Momjian	16:00
Re: [SQL] Turn autocommit off ?	Bruce Momjian	16:02

Sept. 18, 1998

Thread	Author	Time
postmaster dies on complicated views	David Rugge	02:14
Re: [SQL] postmaster dies on complicated views	Bruce Momjian	02:58
PostgreSQL syntax question	Stephen Davies	05:07
SQL equiv to MS-Access Transform	William Leeke	06:39
Re: [SQL] SQL equiv to MS-Access Transform	David Hartwig	12:47
Re: [SQL] PostgreSQL syntax question	Sferacarta Software	13:13
Re: [SQL] PostgreSQL syntax question	Bruce Momjian	16:21
Re: [SQL] Turn autocommit off ?	Peter T Mount	17:29

Sept. 19, 1998

Thread	Author	Time
date problem	Ian Johnston	21:53
Re: [SQL] How to Make Case InSensitive???	Leslie Mikesell	22:48
To create the query for a select where one is NOT in the other	Karl Denninger	22:55

Sept. 20, 1998

Thread	Author	Time
Re: [SQL] To create the query for a select where one is NOT in the other	Eric McKeown	23:23

Sept. 21, 1998

Thread	Author	Time
Re: [SQL] How to Make Case InSensitive???	Bruce Momjian	01:39
Q:Update Rule	Detlef Boddin S/N O.21	10:00
Re: [SQL] Q:Update Rule	Sferacarta Software	13:53
subscribe sql	Deslippe, Michael	17:56
RE: [SQL] To create the query for a select where one is NOT in th e other	Jackson, DeJuan	18:07
Re: [SQL] How to Make Case InSensitive???	Mirek Budzanowski	19:07

Sept. 22, 1998

Thread	Author	Time
Re: [SQL] How to Make Case InSensitive???	Bruce Momjian	16:47
2 questions.	Colin Dick	17:01
Question re: null	Colin Dick	17:37
case-insensitive SORT BY?	Patrick Giagnocavo	19:53
Selecting from float4[] arrays	G. Anthony Reina	20:09
create function syntax question	William Leeke	20:30
Where to find postgres and SQL examples??	William Leeke	20:34
RE: [SQL] To create the query for a select where one is NOT in th e other	Eric McKeown	20:49
Re: [SQL] case-insensitive SORT BY?	Richard Lynch	21:41
RE: [SQL] To create the query for a select where one is NOT in th e other	Jackson, DeJuan	23:09
arrays	Brook Milligan	23:40

Sept. 23, 1998

Thread	Author	Time
subscribe	Lotto	12:13
Re: [SQL] 2 questions.	Chris Johnson	12:44
Re: [SQL] case-insensitive SORT BY?	Chris Johnson	12:47
Re: [SQL] 2 questions.	Sferacarta Software	13:45
Re: [SQL] Question re: null	Sferacarta Software	15:25
Cursors	Glenn Sullivan	15:55
'' != NULL in PostGres???	Neil Harkins	17:41
Re: [SQL] '' != NULL in PostGres???	Brook Milligan	18:10
Re: [SQL] case-insensitive SORT BY?	David Hartwig	18:31
Re: [SQL] '' != NULL in PostGres???	Colin Dick	18:57
Re: [SQL] Cursors	Richard Lynch	20:09
Re: [SQL] '' != NULL in PostGres???	James Olin Oden	21:49

Sept. 24, 1998

Thread	Author	Time
Re: [HACKERS] Re: [SQL] 2 questions.	Thomas G. Lockhart	02:34
Hello everybody,some question!	Tong Hoai Dan	02:42
Re: [HACKERS] Re: [SQL] 2 questions.	Jose' Soares	10:46
Re: [HACKERS] Re: [SQL] 2 questions.	Thomas G. Lockhart	13:50
C compiler error when using PostGres	G. Anthony Reina	20:30
Re: [SQL] C compiler error when using PostGres	John E. Garrott	20:47
Re: [SQL] C compiler error when using PostGres	G. Anthony Reina	21:21
I can't seem to set the -B option on the postmaster over 3000	G. Anthony Reina	22:22

Sept. 25, 1998

Thread	Author	Time
Having trouble with join	G. Anthony Reina	00:49
Re: [SQL] C compiler error when using PostGres	James Olin Oden	11:44

Sept. 26, 1998

Thread	Author	Time
Problems with inserting into tables...	Gemeinschaft Studienarbeit Datenbanken	15:55

Sept. 27, 1998

Thread	Author	Time
Timespan conversion	Herouth Maoz	12:53
Another nut to crack with insertion into tables... *sigh*	Gemeinschaft Studienarbeit Datenbanken	20:46

Sept. 28, 1998

Thread	Author	Time
subscribe	Stan Thomas	07:08
SQL type conversion - text to char/varchar	R.K.Street	09:48
Re: [SQL] Another nut to crack with insertion into tables... *sigh*	Sferacarta Software	13:35
Re: Another nut to crack with insertion into tables... *sigh*	Tom Lane	14:02
Setting current time on insert	Bryan White	14:50
Re: [SQL] Re: Another nut to crack with insertion into tables... *sigh*	Herouth Maoz	16:20

Sept. 29, 1998

Thread	Author	Time
Getting datatype before SELECT	Glenn Sullivan	17:05
Re: [SQL] Getting datatype before SELECT	David Hartwig	21:28

Sept. 30, 1998

Thread	Author	Time
Re: [SQL] Getting datatype before SELECT	D'Arcy J.M. Cain	02:10
Re: [SQL] Getting datatype before SELECT	Bob Smither	02:30
Re: [SQL] Getting datatype before SELECT	James Olin Oden	11:40
Re: [SQL] Getting datatype before SELECT	Bryan White	13:19
Re: [SQL] Getting datatype before SELECT	herouth maoz	22:21

Oct. 1, 1998

Thread	Author	Time
RE: [SQL] Getting datatype before SELECT	Jackson, DeJuan	16:41
Re: [SQL] Getting datatype before SELECT	Glenn Sullivan	17:39

Oct. 2, 1998

Thread	Author	Time
Re: [SQL] Getting datatype before SELECT	D'Arcy J.M. Cain	02:14

Oct. 3, 1998

Thread	Author	Time
grouping a ordered list	phansen	06:50

Oct. 6, 1998

Thread	Author	Time
RE: [SQL] Getting datatype before SELECT	Herouth Maoz	08:54
Still the problem with the autoincrement field	Marc Eggenberger	09:29
Re: [GENERAL] Still the problem with the autoincrement field	Kevin Heflin	09:57
Re: [GENERAL] Still the problem with the autoincrement field	Herouth Maoz	10:08
Re: [SQL] Re: [GENERAL] Still the problem with the autoincrement field	James Oden	11:48
select-querries out of an array?	Gemeinschaft Studienarbeit Datenbanken	15:03
Re: [SQL] select-querries out of an array?	Herouth Maoz	15:09

Oct. 7, 1998

Thread	Author	Time
random tuple	Mauro Bartolomeoli	08:51
RE: [SQL] random tuple	Jackson, DeJuan	16:38
unsubscribe	Florian M Unterkircher	19:52
CASE...WHEN... END	Giovanni Giuffrida	19:59
Updates/Deletes on class*	Gemeinschaft Studienarbeit Datenbanken	22:05

Oct. 8, 1998

Thread	Author	Time
[No subject]	bisheng	05:04
RE: [SQL] random tuple	Mauro Bartolomeoli	12:04
RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'	Jackson, DeJuan	16:29
RE: [SQL] random tuple	Jackson, DeJuan	16:46
Re: [ADMIN] RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'	Terry Mackintosh	18:06

Oct. 9, 1998

Thread	Author	Time
Re: [HACKERS] RE: [SQL] random tuple	Thomas G. Lockhart	04:43

Oct. 11, 1998

Thread	Author	Time
french caracters in Postgresql database ?	Blaise Laurent	09:27

Oct. 12, 1998

Thread	Author	Time
insert/update	David Welton	20:23

Oct. 13, 1998

Thread	Author	Time
Re: [SQL] french caracters in Postgresql database ?	Roberto Joao Lopes Garcia	17:00
correlative insertion	Jorge Maturana Ortiz	22:18

Oct. 14, 1998

Thread	Author	Time
dilemma	Eric McKeown	02:24
Re: [SQL] dilemma	Herouth Maoz	09:46
Re: [SQL] correlative insertion	Herouth Maoz	09:49
Using the IN predicate in an UPDATE...	Thomas Good	13:06
Re: Using the IN predicate in an UPDATE...	Herouth Maoz	14:42
Re: [SQL] Re: Using the IN predicate in an UPDATE...	Gene Selkov Jr.	20:27

Oct. 15, 1998

Thread	Author	Time
Re: [SQL] Using the IN predicate in an UPDATE...	Leslie Mikesell	03:21
Re: [SQL] dilemma	Michael Shields	07:35
Optimizing perfomance using indexes	Vladimir Litovka	12:35
Re: [SQL] Using the IN predicate in an UPDATE...	Thomas Good	12:37
Cluster(ing) to help joins?	pierre	13:53
Re: [SQL] Optimizing perfomance using indexes	Oleg Bartunov	15:09
RE: [SQL] Optimizing performance using indexes	Jackson, DeJuan	15:25
RE: Optimizing performance using indexes	Vladimir Litovka	17:08
Creating Indexes IP and MAC Data Types (followup)	Craig Orsinger	23:11

Oct. 16, 1998

Thread	Author	Time
Optimizing again	Walt Bigelow	01:25
Re: [HACKERS] Re: [SQL] Optimizing perfomance using indexes	Thomas G. Lockhart	06:10
RE: Optimizing performance using indexes	Vladimir Litovka	11:51
Re: [SQL] RE: Optimizing performance using indexes	Bryan White	16:49
Re: Triggers and SQL functions	Philippe Rochat (RSR: 318 17 93)	22:23
Re: Triggers and SQL functions	Philippe Rochat (RSR: 318 17 93)	22:38

Oct. 17, 1998

Thread	Author	Time
Is this BUG or FEATURE?	Vladimir Litovka	13:19
RE: [SQL] Is this BUG or FEATURE?	Taral	17:44
RE: [SQL] Is this BUG or FEATURE?	Vladimir Litovka	17:48

Oct. 18, 1998

Thread	Author	Time
Re: [SQL] Using the IN predicate in an UPDATE...	Herouth Maoz	09:24
NULL DATE	Michel \'ZioBudda\' Morelli	20:28
Re: [SQL] NULL DATE	ZioBudda	20:44
Re: [SQL] NULL DATE	Jan Wieck	20:56
Re: [SQL] NULL DATE	Jan Wieck	21:02
RE: [SQL] NULL DATE	Taral	21:03

Oct. 19, 1998

Thread	Author	Time
`statistical' aggregate functions etc.	Ulf Mehlig	07:39
[SQL, regex, words] how to match word boundaries using regex's?	Tony.Curtis	13:02
PostgreSQL COPY command	Paul Friberg CEO - ISTI	13:03
Re: [SQL] [SQL, regex, words] how to match word boundaries using regex's?	Gene Selkov Jr.	13:33
Re: [SQL] [SQL, regex, words] how to match word boundaries using regex's?	Tony.Curtis	14:58
index not used in like clause...	David Mansfield	18:01
Defaulting to current date	Bryan White	19:31
Defaulting to current date	Bryan White	19:37

Oct. 20, 1998

Thread	Author	Time
timespan question: using value from row in select	Michael Olivier	01:18
Index on VARCHAR faster than TEXT?	Pascal Forget	14:01
RE: [SQL] timespan question: using value from row in select	Jackson, DeJuan	14:46
count(*) and group by's...	Howie	16:59
Re: [SQL] count(*) and group by's...	David Hartwig	17:39

Oct. 21, 1998

Thread	Author	Time
Large Object Interface	Mark Wilson	13:52
Probs with arrays	Gregor Zych	19:54

Oct. 22, 1998

Thread	Author	Time
Re: [SQL] `statistical' aggregate functions etc.	Aleksey Dashevsky	09:45
Re: [SQL] `statistical' aggregate functions etc.	Jan Wieck	10:04
Time format ? (Really microsecond ??)	Philippe Rochat (RSR: 318 17 93)	10:37
Help me ,Thank you !! 📎	ronggui	13:05

Oct. 23, 1998

Thread	Author	Time
Reading and writing at the same time	G. Anthony Reina	18:57

Oct. 24, 1998

Thread	Author	Time
varchar vs. text	Leslie Mikesell	17:37

Oct. 25, 1998

Thread	Author	Time
Re: [SQL] Reading and writing at the same time	Herouth Maoz	09:49

Oct. 26, 1998

Thread	Author	Time
palloc failure: memory exhausted, but ulimit 'unlimited'	Michael Olivier	05:13
idiom to move records?	Leslie Mikesell	05:31
Help on extensended attribute types?	Mike Meyer	08:19
Re: [SQL] idiom to move records?	Herouth Maoz	09:34
Re: [SQL] idiom to move records?	Jan Wieck	10:02
Re: [SQL] idiom to mv recs => [NEW] bleeding lock?	Thomas Good	13:18

Browse Archives

Prev | Next