pgsql-sql since 1998-08-24 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

Aug. 24, 1998

Thread	Author	Time
Subselect in DELETE	Mark Dalphin	01:11
Maximum field in a table	G.Elangovan	16:20
Maximum field in a table	G.Elangovan	16:23
Cursors out of a transaction	David Prieto Carrellan	16:38
parts of date_part()	Eric McKeown	23:33

Aug. 25, 1998

Thread	Author	Time
this one's simpler	Eric McKeown	00:06
copy probs	Cho Yan Wong	02:17
Re: [SQL] this one's simpler	Maarten Boekhold	07:40
Re: [SQL] copy probs	Jose David Martinez Cuevas	15:22
Query otimizing possible?	Andreas Schmidt	15:45
Re: [SQL] parts of date_part()	Brook Milligan	17:20
Having problems to compile SPI	Jose David Martinez Cuevas	18:07
RE: [SQL] Having problems to compile SPI	Taral	18:26
Date vs. Datetime boundaries	Leslie Mikesell	20:52
excel vs. money data type?	Leslie Mikesell	21:55
copying rows	Walt Bigelow	22:38
Once again... triggers 📎	Jose David Martinez Cuevas	23:52

Aug. 26, 1998

Thread	Author	Time
Indexing datetime	Sergei Barbarash	06:51
Re: [SQL] copying rows	Herouth Maoz	08:48
Re: [SQL] parts of date_part()	Herouth Maoz	08:57
Re: [SQL] excel vs. money data type?	David Hartwig	12:54
Re: [SQL] excel vs. money data type?	Leslie Mikesell	15:15
Re: [SQL] parts of date_part()	Leslie Mikesell	16:53
How do I ???	Ian Johnston	20:15
Bug in GROUP BY for INSERT	Pushkar Piggott	23:34

Aug. 27, 1998

Thread	Author	Time
Another bug in GROUP BY for INSERT	Pushkar Piggott	01:00
Re: [SQL] parts of date_part()	Herouth Maoz	08:13
Counter	ADM. Diego Cueva	14:13
copy one to many?	Walt Bigelow	19:38
Re: [SQL] copy one to many?	Bryan White	19:56
Absolute value on int2 or int4 field	Chris Johnson	22:35

Aug. 28, 1998

Thread	Author	Time
Re: [SQL] copy one to many?	Walt Bigelow	03:06
Re: [SQL] Absolute value on int2 or int4 field	Guido Piazzi	08:52
Contertine timespan to hours	Shawn T. Walker	18:17

Aug. 30, 1998

Thread	Author	Time
Re: [SQL] Contertine timespan to hours	Herouth Maoz	08:40
Re: [SQL] copy one to many?	Herouth Maoz	08:58

Aug. 31, 1998

Thread	Author	Time
Re: [SQL] copy probs	Cho Yan Wong	00:36
[No subject] 📎	Johan.F.Strand	11:47

Sept. 1, 1998

Thread	Author	Time
upper() and lower() on varchar	Maarten Boekhold	10:04
pgaccess-forms.	Johann Spies	11:57
Re: [SQL] How to Make Case InSensitive???	Marcio Macedo	14:14
How to Make Case InSensitive???	S.Ramaswamy	16:02
Re: [SQL] How to Make Case InSensitive???	David Hartwig	16:21
rename table - primary key index?	Leslie Mikesell	17:24
Re: [SQL] How to Make Case InSensitive???	David Hartwig	17:47

Sept. 2, 1998

Thread	Author	Time
indexing datetime	Sergei Barbarash	07:07
Re: [SQL] upper() and lower() on varchar	Sferacarta Software	12:33
Re: [SQL] upper() and lower() on varchar	Maarten Boekhold	13:40
Help with setting up table and importing data.	Ronnie Doggart	16:48

Sept. 3, 1998

Thread	Author	Time
Forming Query	Ronnie Doggart	11:56
Resp: [SQL] Concatenation in selects	Fidelis Assis	12:17
Concatenation in selects	James Olin Oden	13:22
Re: [SQL] Concatenation in selects	James Olin Oden	14:16
indexing datetime	Sergei Barbarash	15:11
Resp: RE: Resp: [SQL] Concatenation in selects	Fidelis Assis	17:54
RE: [SQL] rename table - primary key index?	Jackson, DeJuan	18:29
RE: Resp: [SQL] Concatenation in selects	Jackson, DeJuan	18:45
Re: [SQL] Concatenation in selects	Leslie Mikesell	19:33

Sept. 4, 1998

Thread	Author	Time
Re: [SQL] Concatenation in selects	Bruce Momjian	01:04
Re: [SQL] Forming Query	Federico Passaro	08:57
[SQL] composite primary keys.	Stuart Rison	14:21
Re: [SQL] composite primary keys.	Dave	14:49
DECLARE BINARY CURSOR problem	G. Anthony Reina	18:38

Sept. 5, 1998

Thread	Author	Time
Creating Indexes for MAC and IP Data Types 📎	Craig Orsinger	00:15
Re: [SQL] Creating Indexes for MAC and IP Data Types	Bruce Momjian	01:47
Re: [SQL] Creating Indexes for MAC and IP Data Types	The Hermit Hacker	04:33
constraints don't work...	Andrew M Tracey	18:23

Sept. 6, 1998

Thread	Author	Time
Datetime in humane format	Richard Lynch	04:27
Re: [SQL] Datetime in humane format	Herouth Maoz	11:16

Sept. 7, 1998

Thread	Author	Time
Database Client (fwd)	Johann Spies	19:47

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

Browse Archives

Prev | Next